From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Daniel Westermann <daniel(dot)westermann(at)dbi-services(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Which process is actually doing the WAL writes/calls XLogFlush? |
Date: | 2017-06-27 22:52:06 |
Message-ID: | 23321f6b-2409-3b77-5228-02c1d992e65b@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 06/27/2017 11:19 AM, Daniel Westermann wrote:
>>On 06/23/2017 05:50 AM, Daniel Westermann wrote:
>>> Hi all,
>
> Thanks, Adrian
> It is clear now for the asynchronous stuff and wal_writer.
> But I still did not figure out (or I am just not able to understand it from the README linked above)
> which process is actually doing the write to the wal when you have synchronous commit set to on. Can
> someone put some light on this?
ps axjf
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
\_ postgres: logger process
\_ postgres: checkpointer process
\_ postgres: writer process
\_ postgres: wal writer process
\_ postgres: autovacuum launcher process
\_ postgres: stats collector process
\_ postgres: bgworker: pglogical supervisor
AFAIK the wal writer process.
>
> Thanks
> Daniel
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | PT | 2017-06-27 22:57:57 | Re: postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting |
Previous Message | Melvin Davidson | 2017-06-27 22:41:25 | Re: postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting |