Re: BTree index and optimizer - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: BTree index and optimizer
Date
Msg-id 1070533731.3498.4.camel@fuji.krosing.net
Whole thread Raw
In response to BTree index and optimizer  ("Anand, VJ (MED, GEMS-IT)" <Virinchipura.Anand@med.ge.com>)
List pgsql-hackers
Anand, VJ (MED, GEMS-IT) kirjutas K, 03.12.2003 kell 18:18:
>     Hello:
> 
>     I am trying to find out, how is the B-tree index implemented for
> multiple columns? does Postgres, just
>     concatenate the columns --- 

Yes.

> 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?

Yes.

If you want it more complicated, you could check out if PG's R-tree
indexes suit you.

-------------
Hannu



pgsql-hackers by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: *sigh*
Next
From: Bruce Momjian
Date:
Subject: Re: request for feedback - read-only GUC variables, pg_settings