Обсуждение: indices

"David Blood" <david@matraex.com> writes:

> 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 does choose, but each index adds overhead on inserts and updates
(since the indexes have to be updated when the table is) so having
indexes that you don't need will slow you down.

-Doug
--
Doug McNaught       Wireboard Industries      http://www.wireboard.com/

      Custom software development, systems and network consulting.
      Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...