Re: [pgsql-hackers-win32] fsync with sync, and Win32 unlink - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: [pgsql-hackers-win32] fsync with sync, and Win32 unlink
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D019@m0114.s-mxs.net
Whole thread Raw
Responses Re: [pgsql-hackers-win32] fsync with sync, and Win32 unlink
List pgsql-hackers
> Consider either a box with many different postgresql instances, or one
> that run both postgresql and other software. Issuing sync() in that
> sitaution will cause sync of a lot of data that probably doesn't need
> syncing.
> But it'd probably be a very good thing on a dedicated server, giving the
> kernel the chance to optimise.

It is not like the sync is done every few seconds ! It is currently done
every 5 minutes (I actually think this is too frequent now that we have
bgwriter, 10 - 20 min would be sufficient). So imho even on a heavily
otherwise used system the sync will be better.

Andreas

pgsql-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: [pgsql-hackers-win32] fsync with sync, and Win32 unlink
Next
From: Peter Eisentraut
Date:
Subject: Re: unsafe floats