PG wire protocol question

From: Boszormenyi Zoltan <zboszor(at)pr(dot)hu>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: PG wire protocol question
Date: 2016-05-14 19:58:48
Message-ID: 19da09e5-d401-9239-d07d-bc914ad5e3cd@pr.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

it was a long time I have read this list or written to it.

Now, I have a question. This blog post was written about 3 years ago:
https://aphyr.com/posts/282-jepsen-postgres

Basically, it talks about the client AND the server as a system
and if the network is cut between sending COMMIT and
receiving the answer for it, the client has no way to know
whether the transaction was actually committed.

The client connection may just timeout and a reconnect would
give it a new connection but it cannot pick up its old connection
where it left. So it cannot really know whether the old transaction
was committed or not, possibly without doing expensive queries first.

Has anything changed on that front?

There is a 10.0 debate on -hackers. If this problem posed by
the above article is not fixed yet and needs a new wire protocol
to get it fixed, 10.0 would be justified.

Thanks in advance,
Zoltán Böszörményi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2016-05-14 20:47:43 How to use row values as function parameters
Previous Message Adam Brusselback 2016-05-14 17:33:16 Re: Foreign key triggers