On Mon, Dec 20, 2004 at 11:58:21AM -0600, Jaime Casanova wrote:
Jaime,
> I was looking in the archives something about this but
> i found nothing. Where can i found the thread (i
> suppose should be one) about this issue?
Did you use the search engine at http://www.pgsql.ru ?
--
Alvaro Herrera
Jaime Casanova wrote:
> Hi everyone,
>
> >From the TODO items:
> Use index to restrict rows returned by multi-key index
> when used with non-consecutive keys to reduce heap
> accesses.
> For an index on col1,col2,col3, and a WHERE clause of
> col1 = 5 and col3 = 9, spin though the index checking
>
Hi everyone,
>From the TODO items:
Use index to restrict rows returned by multi-key index
when used with non-consecutive keys to reduce heap
accesses.
For an index on col1,col2,col3, and a WHERE clause of
col1 = 5 and col3 = 9, spin though the index checking
for col1 and col3 matches, rather than