Re: Background writer process

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Shridhar Daithankar" <shridhar_daithankar(at)myrealbox(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Background writer process
Date: 2003-11-17 11:15:00
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA496206A@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shridhar Daithankar 2003-11-17 11:58:29 Re: Background writer process
Previous Message Shridhar Daithankar 2003-11-17 10:43:28 Re: start of transaction