COMMIT NOWAIT Performance Option (patch) - Mailing list pgsql-patches

From Simon Riggs
Subject COMMIT NOWAIT Performance Option (patch)
Date
Msg-id 1172530606.3760.440.camel@silverbirch.site
Whole thread Raw
Responses Re: COMMIT NOWAIT Performance Option (patch)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
A prototype patch is posted to -patches, which is WORK IN PROGRESS.
[This patch matches discussion thread on -hackers.]

The following TODO items remain

1. discuss which process will issue regular XLogFlush(). If agreed,
implement WALWriter process to perform this task. (Yes, the patch isn't
fully implemented, yet).
2. remove fsync parameter
3. Prevent COMMIT NOWAIT when commit_delay = 0
4. Discuss whether commit_delay is OK to usurp; twas just an earlier
suggestion from someone else, can go either way.
5. docs

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com


Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Deadlock with pg_dump?
Next
From: Tom Lane
Date:
Subject: Re: COMMIT NOWAIT Performance Option (patch)