On Tue, Sep 17, 2013 at 11:22 AM, Lonni J Friedman <netllama@xxxxxxxxx> wrote:
> c) What does logs say?The postgres server logs look perfectly normal, minus a non-trivial
slower run time for most queries. There's nothing unusual in any of
the OS level logs (/var/log/messages, etc) or dmesg.
Are you generally CPU limited or IO limited?
Grab one of those slower queries and do an "explain (analyze, buffers)" of it. Preferably with track_io_timing on.
Do you still have test/dev/QA/etc copy running on 9.2 for comparison?
Cheers,
Jeff
