Re: Odd sudden performance degradation related to temp object churn

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Jeremy Finzel <finzelj(at)gmail(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Odd sudden performance degradation related to temp object churn
Date: 2017-08-14 22:43:40
Message-ID: CAH2-WznKCt_UBaPEY=WwBof+TkTaDYHbZmDsFE=Vigy3Rqi35A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Aug 14, 2017 at 12:53 PM, Jeremy Finzel <finzelj(at)gmail(dot)com> wrote:
> This particular db is on 9.3.15. Recently we had a serious performance
> degradation related to a batch job that creates 4-5 temp tables and 5
> indexes. It is a really badly written job but what really confuses us is
> that this job has been running for years with no issue remotely approaching
> this one. We are also using pgpool.

Did you happen to notice that this occurred when you upgrading point
release? If so, what version did you move from/to?

--
Peter Geoghegan

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jerry Sievers 2017-08-14 23:10:38 Re: Odd sudden performance degradation related to temp object churn
Previous Message Jerry Sievers 2017-08-14 22:16:36 Re: Odd sudden performance degradation related to temp object churn