Thread: indices
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
"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...