Re: Which index methodology is better?-

"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