BTree index and optimizer

From: "Anand, VJ (MED, GEMS-IT)" <Virinchipura(dot)Anand(at)med(dot)ge(dot)com>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: BTree index and optimizer
Date: 2003-12-03 16:18:52
Message-ID: AAEA486256855E48B59630DB3A684C0D28938C@uswaumsx01medge.med.ge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hello:

I am trying to find out, how is the B-tree index implemented for
multiple columns? does Postgres, just
concatenate the columns --- if this is the case, then how is the
search performed? Also, does the optimizer
choose the index, only when the constraining is on the leading
subset of the index column?

Thanks
VJ

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2003-12-03 17:52:32 Re: Transaction Question
Previous Message Stephan Szabo 2003-12-03 16:07:20 Re: Encoding problem with 7.4