Sequence of processing: WAL / shared buffers

From: Jürgen Purtz <juergen(at)purtz(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Sequence of processing: WAL / shared buffers
Date: 2016-01-28 11:49:56
Message-ID: 56AA0064.1010807@purtz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-novice

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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Wei Shan 2016-01-28 12:57:25 Re: Sequence of processing: WAL / shared buffers
Previous Message Erik Rijkers 2016-01-27 11:32:34 Re: Fwd: [DOCS] pgbench doc typos

Browse pgsql-novice by date

  From Date Subject
Next Message Wei Shan 2016-01-28 12:57:25 Re: Sequence of processing: WAL / shared buffers
Previous Message Kevin Grittner 2016-01-26 15:03:17 Re: Enquiry about setting Up PostgreSQL 8.4 PIRT