Re: Postgresql on file system EXT2 or EXT3

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