On Fri, May 12, 2017 at 7:36 PM, David Fetter <da...@fetter.org> wrote: > On Fri, May 12, 2017 at 06:38:55PM -0400, Peter Eisentraut wrote: >> On 5/12/17 18:13, Alvaro Herrera wrote: >> > I think for logical replication the tuple should appear as being in the >> > parent table, not the partition. No? >> >> Logical replication replicates base table to base table. How those >> tables are tied together into a partitioned table or an inheritance tree >> is up to the system catalogs on each side. > > This seems like a totally reasonable approach to pg_dump, especially > in light of the fact that logical replication already (and quite > reasonably) does it this way. Hard work has been done to make > tuple-routing cheap, and this is one of the payoffs.
Cheap isn't free, though. It's got a double-digit percentage overhead rather than a large-multiple-of-the-runtime overhead as triggers do, but people still won't want to pay it unnecessarily, I think. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers