| 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: | Whole Thread | Raw Message | 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 |