Re: [HACKERS] fsync vs open_sync - Mailing list pgsql-performance

From Josh Berkus
Subject Re: [HACKERS] fsync vs open_sync
Date
Msg-id 200408101018.32327.josh@agliodbs.com
Whole thread Raw
In response to Re: [HACKERS] fsync vs open_sync  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: [HACKERS] fsync vs open_sync
Re: [HACKERS] fsync vs open_sync
List pgsql-performance
Guys, just so you know:

OSDL did some testing and found Ext3 to be perhaps the worst FS for PostgreSQL
-- although this testing was with the default options.   Ext3 involved an
almost 40% write performance penalty compared with Ext2, whereas the penalty
for ReiserFS and JFS was less than 10%.

This concurs with my personal experience.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Column order performance
Next
From: Tom Lane
Date:
Subject: Re: insert waits for delete with trigger