Multiple column index usage question

From: "Jan Muszynski" <postgres(at)jancm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Multiple column index usage question
Date: 2007-01-19 21:53:50
Message-ID: 45B0F79E.32658.AADD9A9@postgres.jancm.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rather simple question, of which I'm not sure of the answer.

If I have a multiple column index, say:
Index index1 on tableA (foo,bar)

and I then:
Select * from "tableA" where foo = <some value>

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

TIA
-jan m

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Russell Smith 2007-01-19 22:41:33 Re: [HACKERS] Autovacuum Improvements
Previous Message Bruce Momjian 2007-01-19 21:36:50 Re: [HACKERS] Autovacuum Improvements