Re: filesystem suggestion for pg

Поиск
Список
Период
Сортировка
От William Yu
Тема Re: filesystem suggestion for pg
Дата
Msg-id bqe0hg$28g5$1@news.hub.org
обсуждение исходный текст
Ответ на filesystem suggestion for pg  (pginfo <pginfo@t1.unisoftbg.com>)
Список 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 по дате отправления:

Предыдущее
От: ow
Дата:
Сообщение: Re: pg_restore and transaction id wraparound
Следующее
От: "Armel HERVE"
Дата:
Сообщение: Re: Problem with pg_dump / pg_restore