Re: [PATCH] Revert default wal_sync_method to fdatasync on Linux 2.6.33+
Marti Raudsepp <marti@juffo.org>
From: Marti Raudsepp <marti@juffo.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Date: 2010-11-05T19:15:26Z
Lists: pgsql-hackers
On Fri, Nov 5, 2010 at 20:13, Tom Lane <tgl@sss.pgh.pa.us> wrote: > I'm less than convinced this is the right approach ... > > If open_dsync is so bad for performance on Linux, maybe it's bad > everywhere? Should we be rethinking the default preference order? Sure, maybe for PostgreSQL 9.1 But the immediate problem is older releases (8.1 - 9.0) specifically on Linux. Something as innocuous as re-building your DB on a newer kernel will radically affect performance -- even when the DB kernel didn't change. So I think we should aim to fix old versions first. Do you disagree? Regards, Marti