Re: Sequence of processing: WAL / shared buffers
| От | Wei Shan |
|---|---|
| Тема | Re: Sequence of processing: WAL / shared buffers |
| Дата | |
| Msg-id | CAFe9ZToZy6tqSUmsNZaRi7igQzw5oQfo1hqO6RBoU3zGd-w4uQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Sequence of processing: WAL / shared buffers (Jürgen Purtz <juergen@purtz.de>) |
| Ответы |
Re: Sequence of processing: WAL / shared buffers
|
| Список | pgsql-novice |
Hi Jurgen,
If synchronous_commit is enabled, transaction commit will wait for WAL records to be written to disk before the command returns a "success" indication to the client. Shared buffers is not involved when commit is issued. For flushing of shared buffers to data files, we can use checkpoint instead. BGWR in charge of writing shared_buffers to the datafiles.
Thanks!
On 28 January 2016 at 19:49, Jürgen Purtz <juergen@purtz.de> wrote:
Hi,
can anyone explain, what happens first during an UPDATE of an indexed column: writing and flushing to WAL or modification of shared buffers? And: both actions are finished before a confirmation is send to the requesting client - or?
Regards, Jürgen Purtz
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
Regards,
Ang Wei Shan
Ang Wei Shan
В списке pgsql-novice по дате отправления: