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

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 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,