Postgres Pro
Downloads
Home   >   mailing lists

Re: Which index methodology is better?- - Mailing list pgsql-performance

From Tom Lane
Subject Re: Which index methodology is better?-
Date
Msg-id 26761.1194292589@sss.pgh.pa.us
Whole thread Raw
In response to Which index methodology is better?-  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-performance
Tree view 
"Chris Hoover" <revoohc@gmail.com> writes:
> Is it better to create 3 indexes, or one index on the three columns?

This is covered in considerable detail in the fine manual:

http://www.postgresql.org/docs/8.2/static/indexes.html

See particularly sections 11.3 and 11.4

            regards, tom lane

pgsql-performance by date:

Previous
From: "Chris Hoover"
Date:
Subject: Which index methodology is better?-
Next
From: Heikki Linnakangas
Date:
Subject: Re: Which index methodology is better?-