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