indices

David Blood wrote:

Is there a point where there are too many indices or does postgres just
chose out of all the indices on a table the one that matches the queries
needs the best?

It chooses the best, but INSERT/UPDATE involve index upkeep, so too many
can be a performance problem.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026