Re: fsync, fdatasync, open_sync, and open_datasync, -- Linux insanity - Mailing list pgsql-hackers

From Tom Lane
Subject Re: fsync, fdatasync, open_sync, and open_datasync, -- Linux insanity
Date
Msg-id 5774.1092238619@sss.pgh.pa.us
Whole thread Raw
In response to fsync, fdatasync, open_sync, and open_datasync, -- Linux insanity  (pgsql@mohawksoft.com)
List pgsql-hackers
Andreas Pflug <pgadmin@pse-consulting.de> writes:
> Tom Lane wrote:
>> I don't think any test that we could build would be as useful as simply
>> trying the different settings with an installation's real workload.

> Benchmarking the real workload isn't always so easy, and might be quite 
> time consuming to obtain meaningful values.

The concern was about whether people might be missing an easy speedup of
2x or more.  I don't think it'd be that hard to tell ;-) if one setting
is an order of magnitude better than another for your workload.  If
there's not an obvious difference then you haven't wasted much effort
checking.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: pg_restore (libpq? parser?) bug in 8
Next
From: Tom Lane
Date:
Subject: Re: We have got a serious problem with pg_clog/WAL synchronization