From: | 高健 <luckyjackgao(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | wal writer process vs writer process vs checkpoint process |
Date: | 2013-10-08 09:39:09 |
Message-ID: | CAL454F3Hs3Yu25H0U9BTw4d=rgDjPPsD+2VesUgO4nVMHFzEzw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
My customer asked me about the relationship about PostgreSQL's following
process:
wal writer process writer process
checkpoint process
Currently My understanding is:
If I execute some DML, then,Firstly , the related operation or data will be
written to wal buffer.
Secondly, the related data will be written to data buffer(shared_buffer).
And because the above data structure, Then
wal writer process will periodically read from wal buffer, then write them
into wal log.
writer process will read from data buffer and then write them into data
file(eg: table).
And checkpointer process will read from data buffer then write them into
wal log according to checkpoint_timeout and checkpoint_segments settings.
Is my understanding right?
Thanks!
Jian Gao
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2013-10-08 09:49:21 | Re: Can checkpoint creation be parallel? |
Previous Message | John R Pierce | 2013-10-08 09:03:11 | Re: Many, many materialised views - Performance? |