ERR ORR <rd0...@gmail.com> 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 (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
