Re: bloom filter indexes?
От | Joshua D. Drake |
---|---|
Тема | Re: bloom filter indexes? |
Дата | |
Msg-id | 1212516745.12052.144.camel@jd-laptop обсуждение исходный текст |
Ответ на | Re: bloom filter indexes? ("Mason Hale" <masonhale@gmail.com>) |
Список | 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@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
В списке pgsql-general по дате отправления: