| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | "David Blood" <david(at)matraex(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: indices |
| Date: | 2002-03-13 16:15:01 |
| Message-ID: | m3g034tpfe.fsf@varsoon.denali.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"David Blood" <david(at)matraex(dot)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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-03-13 16:20:51 | Re: Referential integrity violation |
| Previous Message | Tom Lane | 2002-03-13 15:41:49 | Re: index on large table |