Peter Geoghegan <pg@xxxxxxx> writes: > On Mon, Aug 14, 2017 at 12:53 PM, Jeremy Finzel <finzelj@xxxxxxxxx> 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? The system was last started back in November. Running 9.3.15. Not aware of any host system libs or whatever change recently but will investigate. > > -- > Peter Geoghegan -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
