On Tue, 2008-06-03 at 13:06 -0500, Mason Hale wrote:
> On Tue, Jun 3, 2008 at 12:04 PM, Jeff Davis <pgsql@j-davis.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
