Re: Partitioning WIP patch - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Partitioning WIP patch
Date
Msg-id 20150226092215.GD5268@alap3.anarazel.de
Whole thread Raw
In response to Re: Partitioning WIP patch  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Partitioning WIP patch  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
On 2015-02-26 02:20:21 -0600, Jim Nasby wrote:
> The reason I'd like to do this with partitioning vs plain inheritance is
> presumably as we build out partitioning we'll get very useful things like
> the ability to have FKs to properly partitioned tables. Insert tuple routing
> could also be useful.

The problem there imo isn't so much inheritance, but lack of working
unique checks across partitions. That's something we can implement
independent of this, it's just not trivial.

Greetings,

Andres Freund

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



pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Transactions involving multiple postgres foreign servers
Next
From: Dean Rasheed
Date:
Subject: Re: INSERT ... ON CONFLICT UPDATE and RLS