From: | Wei Shan <weishan(dot)ang(at)gmail(dot)com> |
---|---|
To: | Jürgen Purtz <juergen(at)purtz(dot)de> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Sequence of processing: WAL / shared buffers |
Date: | 2016-01-28 12:57:25 |
Message-ID: | CAFe9ZToZy6tqSUmsNZaRi7igQzw5oQfo1hqO6RBoU3zGd-w4uQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs 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(at)purtz(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
--
Regards,
Ang Wei Shan
From | Date | Subject | |
---|---|---|---|
Next Message | Jürgen Purtz | 2016-01-29 09:54:20 | Re: Sequence of processing: WAL / shared buffers |
Previous Message | Jürgen Purtz | 2016-01-28 11:49:56 | Sequence of processing: WAL / shared buffers |
From | Date | Subject | |
---|---|---|---|
Next Message | Jürgen Purtz | 2016-01-29 09:54:20 | Re: Sequence of processing: WAL / shared buffers |
Previous Message | Jürgen Purtz | 2016-01-28 11:49:56 | Sequence of processing: WAL / shared buffers |