pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Petr Jelinek <petr.jelinek@2ndquadrant.com>
To: Robert Haas <robertmhaas@gmail.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Corey Huinker <corey.huinker@gmail.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Documentation improvements for partitioning
Date: Sun, 26 Feb 2017 19:18:54 +0100
Message-ID: <f6317f9a-7368-b196-207f-2e425e57eff3@2ndquadrant.com> (raw)
In-Reply-To: <CA+TgmoZ9ysS96tjYNKKUpb_kALYAZ_s0nxRQqwKg6XB99cGrNQ@mail.gmail.com>
References: <CADkLM=esKK-DB=8fs6QNZZAa3N4-G9OuPQatAMSFPzmJv2HmPQ@mail.gmail.com>
	<CANP8+jLkrdwjCRGgtepHFJFcwMFj9hX1mRG8=S+mSfB+sAuR1w@mail.gmail.com>
	<bfe2d291-a7da-42d8-1c6f-cfa73817cd26@lab.ntt.co.jp>
	<CANP8+jJBpWocfKrbJcaf3iBt9E3U=WPE_NC8YE6rye+YJ1sYnQ@mail.gmail.com>
	<4ee94808-968a-57d7-c12a-a18f08138a2f@lab.ntt.co.jp>
	<CANP8+jJaE4fcbbtA9vKr83_cCgBfgrWhk92Q1ts-97JAzdmVSw@mail.gmail.com>
	<CA+TgmoZUwj=QYnaK+F7xEf4w_e2g3XxdMnSNZMZjuinHRcOB8A@mail.gmail.com>
	<CANP8+jJOrCZ5KYGGRyp0yuzFZMTck+tWAtkiFdg=Bc6TUedBaw@mail.gmail.com>
	<CA+TgmoZ7QJd_kOYyFUtgHCP2Qyzuv0gQJutqEV9mBDn1jONDKg@mail.gmail.com>
	<20170220203320.GB2672@momjian.us>
	<CA+TgmobhXyo8oe9BJVi5zBge-UQ+EbmZ_zOOC9y6ZgJjC480CQ@mail.gmail.com>
	<CANP8+j+q_nDg6KsBxJvMW2+cXay+tpktoKmN7Gf3wgTgX_5_Ow@mail.gmail.com>
	<CA+TgmobQ4+H9-wBFLz7=31OwTbbLo0Pm_RCjT-UY9mE31wWmRw@mail.gmail.com>
	<CANP8+jKHUJAWkgj=TYoyq8+UC4xz=dNt1mWYzxmTgLhQYniZcQ@mail.gmail.com>
	<CA+TgmoZ9ysS96tjYNKKUpb_kALYAZ_s0nxRQqwKg6XB99cGrNQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On 24/02/17 07:15, Robert Haas wrote:
> On Fri, Feb 24, 2017 at 9:53 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> The good news is that logical replication DOES work with partitioning,
>> but only for a Publication with PUBLISH INSERT, pushing from a normal
>> table to a partitioned one. Which is useful enough for first release.
>>
>> The work on having UPDATE work between partitions can be used to make
>> updates and deletes work in logical replication. That might yet be
>> made to work in this release, and I think we should look into it, but
>> I think it can be left til next release if we try.
> 
> Are you speaking of the case where you want to replicate from an
> unpartitioned table to a partitioned table?  I would imagine that if
> you are replicating between two identical partitioning hierarchies, it
> would just work.  (If not, that's probably a bug, though I don't know
> whose bug.)
> 

Yes same hierarchies will work but mainly because one has to add
partitions themselves to publication currently. I guess that's the
limitation we might have to live with in 10 as adding the whole
partitioned table should probably work for different hierarchies when we
enable it and I am not quite sure that's doable before start of the CF
at this point.

-- 
  Petr Jelinek                  http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (71+ messages)  latest in thread

Message-ID: <f6317f9a-7368-b196-207f-2e425e57eff3@2ndquadrant.com>
Permalink:  ../f6317f9a-7368-b196-207f-2e425e57eff3@2ndquadrant.com/
Also on:    postgresql.org/message-id/f6317f9a-7368-b196-207f-2e425e57eff3@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: petr.jelinek@2ndquadrant.com, robertmhaas@gmail.com, simon@2ndquadrant.com, bruce@momjian.us, Langote_Amit_f8@lab.ntt.co.jp, corey.huinker@gmail.com
  Subject: Re: Documentation improvements for partitioning
  In-Reply-To: <f6317f9a-7368-b196-207f-2e425e57eff3@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox