| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
| Cc: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com> |
| Subject: | Re: Partitioning WIP patch |
| Date: | 2015-02-26 09:22:15 |
| Message-ID: | 20150226092215.GD5268@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2015-02-26 09:27:31 | Re: INSERT ... ON CONFLICT UPDATE and RLS |
| Previous Message | Ashutosh Bapat | 2015-02-26 09:21:53 | Re: Transactions involving multiple postgres foreign servers |