Re: fsync or fdatasync

From: Ragnar Kjørstad <postgres(at)ragnark(dot)vestdata(dot)no>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gaetano Mendola <mendola(at)bigfoot(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: fsync or fdatasync
Date: 2002-09-10 22:49:14
Message-ID: 20020911004914.C30625@vestdata.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Sep 10, 2002 at 05:07:30PM -0400, Bruce Momjian wrote:
> > Anyway - I'm sure this is not enough to convince you, so I'll have to
> > set up a test instead. But not tonight.
>
> Again, that is a test case for only one OS. It is helpful if we are
> going to start doing per-OS defaults, which is something we have talked
> about.

Oh; I assumed that was already the case.

> What would be great is a test program we can run on different
> OS's to find out which is more efficient.

Yes. Bare in mind though, that this is as much a filesystem issue as a
kernel issue. Two different filesystems on the same kernel may behave
very differently.

Of course one can't distribute seperate postgresql in different versions
optimized for differet filesystems, so perhaps it's just as good to
leave the default as it is and rather put some info (e.g. benchmarks for
different setting on different filesystems on different operating
systems, and the benchmark-script itself so people can do their own
tests). This way the default is allright, and users that need to tweek a
little extra have the info they need.

> Remember, in most cases, we are fsync'ing only one block so there is no
> _gathering_ to do.

Yes, I know you said so. But if that's the case for only most cases
there are some cases were it's not - so there is still some potential.

--
Ragnar Kjørstad

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-09-10 23:03:06 Re: fsync or fdatasync
Previous Message Douglas Trainor 2002-09-10 22:33:43 Re: Fw: consulta