Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good

2020-04-04 Thread Tejaswini GC
Hello Julien, The procedure for doing the upgrade is different for AWS. After the PG upgrade we can see many locks in our system we believe this is the main reason for the issue we are facing, I can see these locks when using pg_stat_activity. Along with that few queries which were executing wit

Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good

2020-04-04 Thread Julien Rouhaud
Once again, please don't top post. On Sat, Apr 04, 2020 at 11:57:02AM +0530, Tejaswini GC wrote: > Hello Julien, > > The procedure for doing the upgrade is different for AWS. > And is it possible to know what the procedure was? > > After the PG upgrade we can see many locks in our system we