Re: fsync, fdatasync, open_sync, and open_datasync, --

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql(at)mohawksoft(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: fsync, fdatasync, open_sync, and open_datasync, --
Date: 2004-08-11 17:20:52
Message-ID: 411A5574.8000806@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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. Don't you think that some
test app doing heavy inserts (maybe with multiple processes) would be
sufficient to decide which option is best on that particular machine?

Regards,
Andreas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-11 17:33:18 Re: pg_restore (libpq? parser?) bug in 8
Previous Message Peter Eisentraut 2004-08-11 17:05:10 Re: libpq problem