Re: upgrade from 9.2.x to 9.3 causes significant performance degradation

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Lonni J Friedman <netllama(at)gmail(dot)com>
Cc: Eduardo Morras <emorrasg(at)yahoo(dot)es>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: upgrade from 9.2.x to 9.3 causes significant performance degradation
Date: 2013-09-17 18:28:14
Message-ID: CAMkU=1y0QKT9bPJsHwuMbEgt6ensp_Y-R6Lg+O6Tih3Q=mWQDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2013-09-17 18:28:45 Re: How to compare the results of two queries?
Previous Message Lonni J Friedman 2013-09-17 18:22:23 Re: upgrade from 9.2.x to 9.3 causes significant performance degradation