Le 2012-12-27 à 12:10, Nikolas Everett a écrit : > We just upgraded from 8.3 to 9.1 and we're seeing some performance problems. > When we EXPLAIN ANALYZE our queries the explain result claim that the queries > are reasonably fast but the wall clock time is way way longer. Does anyone > know why this might happen? > > Like so: > db=>\timing > db=>EXPLAIN ANALYZE SELECT max(id) FROM foo WHERE blah_id = 1209123; > > The plan is sensible. The estimates are sensible. The actual DB time reads > like it is very sensible. But the wall clock time is like 11 seconds and the > \timing report confirms it. > > Any ideas?
Could you post the actual plans? On both versions? That would help a lot. Also, http://explain.depesz.com/ helps readability. Bye, François -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
