On Tue, Sep 17, 2013 at 11:22 AM, Lonni J Friedman <netllama@gmail.com> 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?