Re: [HACKERS] multi-key index

2004-12-20 Thread Alvaro Herrera
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

Re: [HACKERS] multi-key index

2004-12-20 Thread Bruce Momjian
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 >

[HACKERS] multi-key index

2004-12-20 Thread Jaime Casanova
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