From: | Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com> |
---|---|
To: | Erik Rijkers <er(at)xs4all(dot)nl> |
Cc: | Andres Freund <andres(at)anarazel(dot)de>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Steve Singer <steve(at)ssinger(dot)info>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-hackers-owner(at)postgresql(dot)org |
Subject: | Re: Logical Replication WIP |
Date: | 2016-12-18 10:12:22 |
Message-ID: | cfb04a9b-73bf-a1d6-9961-4892375a4a6c@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 17/12/16 13:37, Erik Rijkers wrote:
> On 2016-12-16 13:49, Petr Jelinek wrote:
>>
>> version 13 of the patch.
>>
>> 0001-Add-PUBLICATION-catalogs-and-DDL-v13.patch.gz (~32 KB)
>> 0002-Add-SUBSCRIPTION-catalog-and-DDL-v13.patch.gz (~28 KB)
>> 0003-Define-logical-rep...utput-plugi-v13.patch.gz (~13 KB)
>> 0004-Add-logical-replication-workers-v13.patch.gz (~44 KB)
>> 0005-Add-separate-synch...or-logical--v13.patch.gz (~2 KB)
>
> Hi,
>
> You wrote on 2016-08-05: :
>
>> What's missing:
>> - sequences, I'd like to have them in 10.0 but I don't have good
>> way to implement it. PGLogical uses periodical syncing with some
>> buffer value but that's suboptimal. I would like to decode them
>> but that has proven to be complicated due to their sometimes
>> transactional sometimes nontransactional nature, so I probably
>> won't have time to do it within 10.0 by myself.
>
> I ran into problems with sequences and I wonder if sequences-problems
> are still expected, as the above seems to imply.
>
> (short story: I tried to run pgbench across logical replication; and
> therefore
> added a sequence to pgbench_history to give it a replica identity, and
> cannot get it to work reliably ).
>
Sequences are not replicated but that should not prevent pgbench_history
itself from being replicated when you add serial to it.
BTW you don't need to add primary key to pgbench_history. Simply ALTER
TABLE pgbench_history REPLICA IDENTITY FULL; should be enough.
--
Petr Jelinek http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Petr Jelinek | 2016-12-18 10:28:17 | Re: Logical Replication WIP |
Previous Message | Craig Ringer | 2016-12-18 02:29:51 | Re: delta relations in AFTER triggers |