| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Mason Hale <masonhale(at)gmail(dot)com> |
| Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: bloom filter indexes? |
| Date: | 2008-06-03 18:12:25 |
| Message-ID: | 1212516745.12052.144.camel@jd-laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2008-06-03 at 13:06 -0500, Mason Hale wrote:
> On Tue, Jun 3, 2008 at 12:04 PM, Jeff Davis <pgsql(at)j-davis(dot)com> wrote:
> > On Tue, 2008-06-03 at 09:43 -0500, Mason Hale wrote:
> >> I've been working on partitioning a rather large dataset into multiple
> >> tables. One limitation I've run into the lack of cross-partition-table
> >> unique indexes. In my case I need to guarantee the uniqueness of a
> >> two-column pair across all partitions -- and this value is not used to
> >> partition the tables. The table is partitioned based on a insert date
> >> timestamp.
> >
> > You're looking for a constraint across tables.
> >
>
> Yes, for this particular case. But I'm also interested in speeding up
> cross-partition queries whether it is for a uniqueness check or not.
> This uniqueness check is just one (important) instance of a
> cross-partition query.
I simple way to do this (potentially) would be to push the trigger to C.
Joshua D. Drake
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2008-06-03 18:35:10 | Re: PostgreSQL 8.3 XML parser seems not to recognize the DOCTYPE element in XML files |
| Previous Message | Mason Hale | 2008-06-03 18:06:15 | Re: bloom filter indexes? |