On Tue, Sep 17, 2013 at 11:22 AM, Lonni J Friedman <netllama(at)gmail(dot)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?
Cheers,
Jeff