On Tue, 2008-06-03 at 13:06 -0500, Mason Hale wrote:
> On Tue, Jun 3, 2008 at 12:04 PM, Jeff Davis <pgsql@[EMAIL PROTECTED]
> 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 (im****tant) instance of a
> cross-partition query.
I simple way to do this (potentially) would be to push the trigger to C.
Joshua D. Drake
--
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
