Re: filesystem suggestion for pg

From: William Yu <wyu(at)talisys(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: filesystem suggestion for pg
Date: 2003-12-01 00:04:04
Message-ID: bqe0hg$28g5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2003-12-01 07:29:57 Re: [HACKERS] initdb should create a warning message [was Re:
Previous Message Neil Conway 2003-11-30 23:18:54 Re: [HACKERS] initdb should create a warning message [was Re: