Postgres Pro
Downloads
Home   >   mailing lists

Re: Long text values destroys logical replication slots - Mailing list pgsql-bugs

From Andres Freund
Subject Re: Long text values destroys logical replication slots
Date
Msg-id 853C54D9-7168-4852-99CF-49DCA1A7B48C@anarazel.de
Whole thread Raw
In response to Long text values destroys logical replication slots  (Adam Dratwiński <adam.dratwinski@gmail.com>)
Responses Re: Long text values destroys logical replication slots  (Adam Dratwiński <adam.dratwinski@gmail.com>)
List pgsql-bugs
Tree view 
On October 28, 2015 7:51:18 PM GMT+01:00, "Adam Dratwiński" <adam.dratwinski@gmail.com> wrote:
>I recently encountered a bug on my production postgres which results in
>killing replication slot. It happens when there is an UPDATE statement
>called on a record having text column with a very long value (about
>1mb).
>The problem can be easily reproduced by this query:
>
>https://gist.github.com/adwinsky/f7a6dc4382776fb9ea60
>
>Here I am using decoderbufs decoder
>https://github.com/krzychk/decoderbufs
>but it doesn't seems to be related with this plugin as it also happen
>on
>the postgres test decoder.

Did you try the last minor release?

Andres
Hi
---
Please excuse brevity and formatting - I am writing this on my mobile phone.

pgsql-bugs by date:

Previous
From: Adam Dratwiński
Date:
Subject: Long text values destroys logical replication slots
Next
From: Andres Freund
Date:
Subject: Re: Long text values destroys logical replication slots