Re: [HACKERS] fsync vs open_sync

From: pgsql(at)mohawksoft(dot)com
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: [HACKERS] fsync vs open_sync
Date: 2004-08-10 18:04:52
Message-ID: 33646.64.119.142.34.1092161092.squirrel@mail.mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

I had exactly the same experience

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-08-10 18:18:05 Re: Slow select, insert, update
Previous Message Josh Berkus 2004-08-10 17:23:28 Re: Column order performance