Greg Stark wrote:
>I think what you're trying to accomplish is better accomplished through
>partitioned tables. Then the user can decide which keys to use to partition
>the data and the optimizer can use the data to completely exclude some
>partitions from consideration. And it wouldn't interfere with indexes to
>access the data within a partition.
Though partitioning will help, you can only partition on one key (I
guess the ability to partition *indexes* might help here).
I think that bitmap indexes provide a flexible may to get fact access to
the result set for multiple low cardinality conditions - something that
partitioning will generally not do.
In response to
pgsql-hackers by date
|Next:||From: Mark Kirkwood||Date: 2004-10-27 21:07:09|
|Subject: Re: plans for bitmap indexes?|
|Previous:||From: ohp||Date: 2004-10-27 20:31:44|
|Subject: Re: Unixware 714 pthreads|