On Mon, Aug 14, 2017 at 5:10 PM, Jerry Sievers <[email protected]> wrote: > Peter Geoghegan <[email protected]> writes: > >> On Mon, Aug 14, 2017 at 12:53 PM, Jeremy Finzel <[email protected]> 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.
So do iostat or iotop show you if / where your disks are working hardest? Or is this CPU overhead that's killing performance? -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
