...
One cause of this has been found to be PostgreSQL tables that have a large amount of dead tuples (data that has been deleted or obsoleted). In order to maintain optimum performance, tables should regularly (perhaps nightly) have these removed by use of the VACUUM command. This command reclaims the space taken by this dead data, improving the performance of subsequent SQL operations.
...