Re: [PERFORM] Odd sudden performance degradation related to tempobject churn - Mailing list pgsql-performance

From Peter Geoghegan
Subject Re: [PERFORM] Odd sudden performance degradation related to tempobject churn
Date
Msg-id CAH2-WznKCt_UBaPEY=WwBof+TkTaDYHbZmDsFE=Vigy3Rqi35A@mail.gmail.com
Whole thread Raw
In response to [PERFORM] Odd sudden performance degradation related to temp object churn  (Jeremy Finzel <finzelj@gmail.com>)
Responses Re: [PERFORM] Odd sudden performance degradation related to temp object churn
List pgsql-performance
On Mon, Aug 14, 2017 at 12:53 PM, Jeremy Finzel <finzelj@gmail.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


pgsql-performance by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: [PERFORM] Odd sudden performance degradation related to temp object churn
Next
From: Jerry Sievers
Date:
Subject: Re: [PERFORM] Odd sudden performance degradation related to temp object churn