Re: BUG #13725: Logical Decoding - wrong results with large transactions and unfortunate timing

From: Andres Freund <andres(at)anarazel(dot)de>
To: ofir(dot)manor(at)gmail(dot)com
Cc: "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13725: Logical Decoding - wrong results with large transactions and unfortunate timing
Date: 2015-10-26 11:30:06
Message-ID: 20151026113006.GB620@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2015-10-26 13:21:44 +0200, ofir(dot)manor(at)gmail(dot)com wrote:
> Yes, this is a small script to reproduce, the real code is Java, we saw
> sporadic wrong results.
> However, I'm interested in CDC (get change notifications per row to my
> app), not PG-to-PG replication.

The streaming interface exists for row-by-row notification as well, and
is a *LOT* more efficient.

If there's a bug here, we obviously need to fix it nonetheless.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Shulgin, Oleksandr 2015-10-26 11:34:48 Re: BUG #13725: Logical Decoding - wrong results with large transactions and unfortunate timing
Previous Message ofir.manor 2015-10-26 11:21:44 Re: BUG #13725: Logical Decoding - wrong results with large transactions and unfortunate timing