Re: High update activity, PostgreSQL vs BigDBMS - Mailing list pgsql-performance

From Geoffrey
Subject Re: High update activity, PostgreSQL vs BigDBMS
Date
Msg-id 459A666E.9090508@3times25.net
Whole thread Raw
In response to Re: High update activity, PostgreSQL vs BigDBMS  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: High update activity, PostgreSQL vs BigDBMS  (Ragnar <gnari@hive.is>)
List pgsql-performance
Alvaro Herrera wrote:
> Ron wrote:
>
>> C= What file system are you using?  Unlike BigDBMS, pg does not have
>> its own native one, so you have to choose the one that best suits
>> your needs.  For update heavy applications involving lots of small
>> updates jfs and XFS should both be seriously considered.
>
> Actually it has been suggested that a combination of ext2 (for WAL) and
> ext3 (for data, with data journalling disabled) is a good performer.
> AFAIK you don't want the overhead of journalling for the WAL partition.

I'm curious as to why ext3 for data with journalling disabled?  Would
that not be the same as ext2?

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

pgsql-performance by date:

Previous
From: Rolf Østvik
Date:
Subject: Re: Worse perfomance on 8.2.0 than on 7.4.14
Next
From: Ragnar
Date:
Subject: Re: High update activity, PostgreSQL vs BigDBMS