Postgres Pro
Downloads
Home   >   mailing lists

Multiple column index question. - Mailing list pgsql-general

From Jan Muszynski
Subject Multiple column index question.
Date
Msg-id 45B0E224.6782.A59F71D@jan.jancm.org
Whole thread Raw
Responses Re: Multiple column index question.  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view 
If I have an index that's composed of 2 columns:
    Index index1 on tableA (foo,bar)

and I then:
    Select cola, colb from tableA where foo=<value>

Will index1 still be used, or am I looking at a seqscan under all
circumstances in this case?

TIA
-jan m

pgsql-general by date:

Previous
From: sjarosz@gmail.com
Date:
Subject: Re: Who is Slony Master/Slave + general questions.
Next
From: Michael Raven
Date:
Subject: Re: copy row tree