Re: Postgresql on file system EXT2 or EXT3

On Thu, 27 Nov 2003 13:03:41 -0500 "Keith C. Perry" <netadmin(at)vcsn(dot)com> wrote:
> Quoting Carmen Wai <wai_carmen(at)hotmail(dot)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(at)averillpark(dot)net
Averill Park Networking 518-573-7592
Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security