[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 just col1; also
called skip-scanning. 


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?

regards,
Jaime Casanova

_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

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
 for col1 and col3 matches, rather than just col1; also
 called skip-scanning. 
 
 
 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?

I don't remember any detailed discussion on it except that it would be a
good idea.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 8: explain analyze is your friend

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 ([EMAIL PROTECTED])
Before you were born your parents weren't as boring as they are now. They
got that way paying your bills, cleaning up your room and listening to you
tell them how idealistic you are.  -- Charles J. Sykes' advice to teenagers

---(end of broadcast)---
TIP 8: explain analyze is your friend