Search Postgresql Archives

Re: xlog vs. shmfs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Apr 20, 2009 at 09:28:20PM +0800, Botao Pan wrote:
> I know that it's guaranteed to cause problems when putting xlog in a
> disk mounted from shared memory, but in what scale? Am I looking at
> data loss or full database cluster corruption? I'm running postgresql
> 8.2.4.

There is no essential difference between the data in your user tables
and the data in the catalogs that let you read your own data. So
corruption could be anything between losing some data in your tables to
complete wiping out of columns or tables or even the entire DB (if
you're unlucky).

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog@xxxxxxxxx>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while 
> boarding. Thank you for flying nlogn airlines.

Attachment: signature.asc
Description: Digital signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux