| From: | Markus Schiltknecht <markus(at)bluegap(dot)ch> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, NikhilS <nikkhils(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Auto Partitioning |
| Date: | 2007-04-04 19:34:03 |
| Message-ID: | 4613FDAB.6080501@bluegap.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Hi,
Joshua D. Drake wrote:
> If we don't have multi-table indexes how do we enforce a primary key
> against a partitioned set?
The executor would have to be clever enough to not do a single index
scan, but possibly scan through multiple indexes when asking for
uniqueness, depending on the partitioning rule set.
Regards
Markus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zoltan Boszormenyi | 2007-04-04 19:35:16 | Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch |
| Previous Message | Andrew Dunstan | 2007-04-04 19:26:44 | Re: Auto Partitioning |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zoltan Boszormenyi | 2007-04-04 19:35:16 | Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch |
| Previous Message | Andrew Dunstan | 2007-04-04 19:26:44 | Re: Auto Partitioning |