Re: Recomended FS

Mark Kirkwood <markir@paradise.net.nz>

From: Mark Kirkwood <markir@paradise.net.nz>
To: "scott.marlowe" <scott.marlowe@ihs.com>
Cc: Steve Crawford <scrawford@pinpointresearch.com>, pgsql-general@postgresql.org, jd@commandprompt.com
Date: 2003-10-23T19:23:27Z
Lists: pgsql-general
Its worth checking - isn't it ?

I appeciate that you may have performed such tests previously - but as 
hardware and software evolve its often worth repeating such tests (goes 
away to do the suggested one tonight).

Note that I am not trying to argue away the issue about write caching - 
it *has* to increase the risk of database corruption following a power 
failure, however if your backups are regular and reliable this may be a 
risk worth taking to achieve acceptable performance at a low price.

regards

Mark


scott.marlowe wrote:

>
>Assuming that the caching was on, I'm betting your database won't survive 
>a power plug pull in the middle of transactions like the test I put up 
>above.
>
>  
>