Home > mailing lists

Question about indexes - Mailing list pgsql-general

From	Stefano Bonnin
Subject	Question about indexes
Date	November 15, 2004 13:33:16
Msg-id	003101c4caff$3ec3ff40$0501a8c0@comai04 Whole thread Raw
List	pgsql-general

Only a simple question

I have a table with

primarykey(field1,field2,field3)

and I want to execure a query like

select * from my_table where field1 = some_value

if I define an index on field1, I increase the query performace or not?

Thanks

From: Richard Huxton
Date: 15 November 2004, 12:37:26
Subject: Re: suggestion for "psql"

From: Martijn van Oosterhout
Date: 15 November 2004, 13:35:45
Subject: Re: OID