Re: Specific query taking time to process

2020-01-30 Thread Fahiz Mohamed
Hi Jeff, Thank you for your email, Sorry I couldn’t respond back to you. I am not working on this project at the moment. I have copied one of my colleague who working on this. He has some progress on this, he will update the email thread with those findings Appreciate your support. Thank you,

Re: Specific query taking time to process

2020-01-30 Thread Duncan Whitham
I have read through your comments so far – and they tally with the checks we have been making to an extent – thanks for them. We now only need 1 environment as we can replicate the performance problem on a copy of live – snapshot/restore from AWS of live. We now have a vacuum analyse running ev

Re: Specific query taking time to process

2020-01-30 Thread Tom Lane
Duncan Whitham writes: > We now only need 1 environment as we can replicate the performance problem > on a copy of live – snapshot/restore from AWS of live. We now have a vacuum > analyse running every night on the 3 tables in question on live – to > eliminate bloat and inaccurate stats as the ro