Serializable read and blocking

From: Rakesh Kumar <rakeshkumar464a3(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Serializable read and blocking
Date: 2016-08-11 12:11:32
Message-ID: CAJBB=EUSYHxOoJtu5W9cpyZcK9rT9QDir65Z+Ga-+DVe4RtBqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

As per this blog post

http://bonesmoses.org/2016/07/29/pg-phriday-constipated-connections/

I have a question which I asked there too, but unfortunately did not
receive any answer.

The question is re the following claim:

- Readers do not block readers.
- Readers do not block writers.
- Writers do not block readers.
- Writers may block writers.

Are the above statements true even with SET TRANSACTION SERIALIZEABLE mode.
I am specifically interested in the 3rd condition (- Writers do not
block readers.)

thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2016-08-11 12:34:37 Re: Serializable read and blocking
Previous Message Martín Marqués 2016-08-11 11:55:56 Re: upgrade to repmgr3