Re: Postgresql on file system EXT2 or EXT3 - Mailing list pgsql-general

From Richard Welty
Subject Re: Postgresql on file system EXT2 or EXT3
Date
Msg-id Mahogany-0.66.0-19024-20031127-131513.00@averillpark.net
Whole thread Raw
In response to Re: Postgresql on file system EXT2 or EXT3  ("Keith C. Perry" <netadmin@vcsn.com>)
List pgsql-general
On Thu, 27 Nov 2003 13:03:41 -0500 "Keith C. Perry" <netadmin@vcsn.com> wrote:
> Quoting Carmen Wai <wai_carmen@hotmail.com>:
> > records to the two machines, I found that the machine with EXT2 insert much
> > quicker than the other with EXT3.

> > Is postgresqk perform better with EXT2 file system?

> Keep in mind that with a journaling type fs, you have additional overhead for
> the journal.  I've heard people make this comment before about EXT 3 being
> slower that EXT 2.

based on what i've heard hanging out on various postgresql lists, try EXT3
with journaling of meta data only for the database files.

richard
--
Richard Welty                                         rwelty@averillpark.net
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

pgsql-general by date:

Previous
From: "Keith C. Perry"
Date:
Subject: Re: Postgresql on file system EXT2 or EXT3
Next
From: javier garcia - CEBAS
Date:
Subject: 7.3.4 and 7.4 ORDER in queries