Re: filesystem suggestion for pg - Mailing list pgsql-admin

From William Yu
Subject Re: filesystem suggestion for pg
Date
Msg-id bqe0hg$28g5$1@news.hub.org
Whole thread Raw
In response to filesystem suggestion for pg  (pginfo <pginfo@t1.unisoftbg.com>)
List pgsql-admin
> Also for this time we do not have any problems with oracle servers (and
> we have had many power downs).
>
 > (...stuff...)
 >
> We found that ext3 is less stable comparing to reiserfs and we need to
> use fsck.
> We are using ~300 tables with ~3M rows (max) .
> Also we are using mostly dual pentium + IDE disks.

The problem is invalid shutdowns + IDE. You must turn off write caching
at the IDE hard drive level to ensure proper data integrity with
Postgres. Oracle gets away with it because it uses a double or triple
redo log while Postgres just uses a single write-ahead log.


pgsql-admin by date:

Previous
From: ow
Date:
Subject: Re: pg_restore and transaction id wraparound
Next
From: "Armel HERVE"
Date:
Subject: Re: Problem with pg_dump / pg_restore