Re: Filesystem options for storing pg_data

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Filesystem options for storing pg_data
Дата
Msg-id 1114014561.20921.578.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: Filesystem options for storing pg_data  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
On Wed, 2005-04-20 at 11:18, Scott Marlowe wrote:
> On Wed, 2005-04-20 at 11:07, Joe Maldonado wrote:
> > Hello all,
> >
> > I am in a position where I'm torn between using ext2 vs ext3 to keep the
> > pg_data, pg_xlog, and pg_clog contents.
> >
> > The main concern is that switching to ext2 will not respond well to an
> > improper shutdown, power loss.
> >
> > My question is what is the prefered filesystem to keep this data to be
> > able to optimize performance and still have some fault tolerance.
>
> Generally XFS and JFS are considered superior to ext2/3.
>
> ext3, in my experience, isn't much slower than ext2.  Plus the decreased
> time required to bring up a server after a power outage is worth
> something too.
>
> Having used ext3 quite a bit, I'd say it's fairly stable and reliable,
> but I have seen references here to know, possibly unfixable bugs.
>
> I've used XFS a few years back, and there was no great gain for what we
> were doing at the time, as we were CPU, not I/O bound.

Oh, and if you use ext3, definitely turn off atime (use the noatime
option at mount time)

В списке pgsql-general по дате отправления:

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: What means Postgres?
Следующее
От: David Gagnon
Дата:
Сообщение: Re: Regular expression. How to disable ALL meta-character