On 06/23/2017 05:50 AM, Daniel Westermann wrote:
Hi all,
as I did not find the answer in the documentation: Which background
process is actually doing the writes/flushes to the WAL? In the docs
(https://www.postgresql.org/docs/10/static/wal-configuration.html) it is
explained which internal functions are responsible for this:
XLogInsertRecord and XLogFlush but who does call them, especially the
flush? Is it the process for the user connection itself then which calls
this after commit?
For all the details see here:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/access/transam/README;h=4ae4715339e707ab5ed879a628aa96b73002ef43;hb=6a18e4bc2d13d077c52cf90a4c6ec68343808ba7
Initially I thought it is the job of the wal_writer but according to
this blog post
(http://www.cybertec.at/postgresql-writer-and-wal-writer-processes-explained/)
this seems not to be true, right? Why do I need the wal_writer at all
then when synchronous_commit is set to something else than off?
See here:
https://www.postgresql.org/docs/9.6/static/wal-async-commit.html
Thanks for your help
Daniel
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
