Re: Transactions over pathological TCP connections

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Leon Smith <leon(dot)p(dot)smith(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Transactions over pathological TCP connections
Date: 2012-06-19 15:59:43
Message-ID: CA+TgmoanfeGDdyFkFBx7WCnMv64u6Zoz+-gKUrL-K-=AU7NE+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 19, 2012 at 1:56 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> The transaction would be committed before a command success report is
> delivered to the client, so I don't think delivered-and-not-marked is
> possible.

...unless you have configured synchronous_commit=off, or fsync=off.

Or unless your disk melts into a heap of slag and you have to restore
from backup. You can protect against that last case using synchronous
replication.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-06-19 16:11:20 Re: [PATCH 10/16] Introduce the concept that wal has a 'origin' node
Previous Message Fujii Masao 2012-06-19 15:57:49 Re: Skip checkpoint on promoting from streaming replication