ERR ORR <[email protected]> wrote: > the fact that in 9.2.4 it is so bad that a simple query sometimes > does not finish after 10+ minutes with incessant disk activity > tends to look like a problem to me.
Try running a VACUUM FREEZE ANALYZE; command on the database, under a database superuser ID. If you upgraded with pg_dump (or some other logical population of the data, versus a pg_upgrade run) you are probably getting bitten by the initial setting of hint bits. http://wiki.postgresql.org/wiki/Hint_Bits See if it is still slow after that.... -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
