Re: Which process is actually doing the WAL writes/calls XLogFlush?

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

In response to

Responses

Browse pgsql-general by date

  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