Thread: indices

indices

From

"David Blood"

Date:

07 March 2002, 18:56:32

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?

david

Re: indices

From

Bruce Momjian

Date:

07 March 2002, 19:24:38

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