BTree index and optimizer - Mailing list pgsql-hackers

From Anand, VJ (MED, GEMS-IT)
Subject BTree index and optimizer
Date
Msg-id AAEA486256855E48B59630DB3A684C0D28938C@uswaumsx01medge.med.ge.com
Whole thread Raw
Responses Re: BTree index and optimizer  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
Hello:
I am trying to find out, how is the B-tree index implemented for
multiple columns? does Postgres, justconcatenate the columns --- if this is the case, then how is the
search performed? Also, does the optimizerchoose the index, only when the constraining is on the leading
subset of the index column?
ThanksVJ 


pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Encoding problem with 7.4
Next
From: julius
Date:
Subject: postgresql-7.4 make error: tuptoaster.c: In function `toast_delete_datum'