| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: fsync method checking |
| Date: | 2004-03-18 18:23:14 |
| Message-ID: | 4059E912.2050509@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Bruce Momjian wrote:
>I have been poking around with our fsync default options to see if I can
>improve them. One issue is that we never default to O_SYNC, but default
>to O_DSYNC if it exists, which seems strange.
>
>What I did was to beef up my test program and get it into CVS for folks
>to run. What I found was that different operating systems have
>different optimal defaults. On BSD/OS and FreeBSD, fdatasync/fsync was
>better, but on Linux, O_DSYNC/O_SYNC was faster.
>
>[snip]
>
>Linux 2.4.9:
>
>
This is a pretty old kernel (I am writing from a machine running 2.4.22)
Maybe before we do this for Linux testing on a more modern kernel might
be wise.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-03-18 18:32:08 | Re: Further thoughts about warning for costly FK checks |
| Previous Message | Tom Lane | 2004-03-18 17:56:45 | Re: syntax error position "CREATE FUNCTION" bug fix |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-03-18 18:40:43 | Re: fsync method checking |
| Previous Message | Stephan Szabo | 2004-03-18 17:57:50 | Re: PostgreSQL Disk Usage and Page Size |