December 2006

You are browsing the archive for December 2006.

Postgresql and multiple indexes in table

Just a quick note for warm-up. Recent server maintenance and test showed me, that postgresql behaves badly when there are more than couple indexes on the same table. We have some tables that are used in various queries using quite many criteria to determine the result, thus more than couple indexes looks possible (10-15 in [...]