Why does PostgresQL query performance drop over time, but restored when rebuilding index
- by Jim Rush
According to this page in the manual, indexes don't need to be maintained. However, we are running with a PostgresQL table that has a continuous rate of updates, deletes and inserts that over time (a few days) sees a significant query degradation. If we delete and recreate the index, query performance is restored.
We are using out of the box…