David Garamond <[EMAIL PROTECTED]> writes:
> explain tells me it is using the partial index. But when I create
> partial index on the id column (BYTEA):
> create unique index i_partition_id_000 on partition(id)
> where id like '\\000%';
> explain select * from partition where id like '\\000
Table of 2mil records, two columns: id (BYTEA/GUID, PK) and i (INT,
UNIQUE INDEX). i values range from 1 to 200.
I'm creating several partial index for i as follows:
create unique index i_partition_i_1to100k on partition(i)
where i>=0 and i<=10;
create unique index i_partition_i_100k1
