Re: Proposed LogWriter Scheme, WAS: Potential Large Performance Gain in WAL synching - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: Proposed LogWriter Scheme, WAS: Potential Large Performance Gain in WAL synching
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961EB3@m0114.s-mxs.net
Whole thread Raw
In response to Proposed LogWriter Scheme, WAS: Potential Large Performance Gain in WAL synching  ("Curtis Faith" <curtis@galtair.com>)
List pgsql-hackers
> > Keep in mind that we support platforms without O_DSYNC.  I am not
> > sure whether there are any that don't have O_SYNC either, but I am
> > fairly sure that we measured O_SYNC to be slower than fsync()s on
> > some platforms.

This measurement is quite understandable, since the current software
does 8k writes, and the OS only has a chance to write bigger blocks in the
write+fsync case. In the O_SYNC case you need to group bigger blocks yourself.
(bigger blocks are essential for max IO)

I am still convinced, that writing bigger blocks would allow the fastest
solution. But reading the recent posts the solution might only be to change
the current "loop foreach dirty 8k WAL buffer write 8k" to one or two large
write calls.

Andreas


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: [GENERAL] Large databases, performance