Re: Background writer process - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: Background writer process
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA496206A@m0114.s-mxs.net
Whole thread Raw
In response to Background writer process  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Background writer process
List pgsql-hackers
> 1. Open WAL files with O_SYNC|O_DIRECT or O_SYNC(Not sure if

Without grouping WAL writes that does not fly. Iff however such grouping
is implemented that should deliver optimal performance. I don't think flushing
WAL to the OS early (before a tx commits) is necessary, since writing 8k or 256k
to disk with one call takes nearly the same time. The WAL write would need to be
done as soon as eighter 256k fill or a txn commits.

Andreas


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: start of transaction (was: Re: [PERFORM] Help with
Next
From: Christopher Kings-Lynne
Date:
Subject: commenting on polymorphic aggregates possible?