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