Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues.

2020-04-02 Thread postgann2020 s
Thanks Adrian, will share the details. On Fri, Apr 3, 2020 at 4:30 AM Adrian Klaver wrote: > On 4/2/20 12:37 PM, postgann2020 s wrote: > > Hi Team, > > > > Good Evening, > > > > Could someone please help us share the procedure to troubleshoot the > > locks on proc issues. > > > > Environment: >

Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues.

2020-04-02 Thread Adrian Klaver
On 4/2/20 12:37 PM, postgann2020 s wrote: Hi Team, Good Evening, Could someone please help us share the procedure to troubleshoot the locks on proc issues. Environment:  1 pgpool server (Master Pool Node) using Straming replication with load balancing  4 DB nodes (1Master

Could someone please help us share the procedure to troubleshoot the locks on proc issues.

2020-04-02 Thread postgann2020 s
Hi Team, Good Evening, Could someone please help us share the procedure to troubleshoot the locks on proc issues. Environment: 1 pgpool server (Master Pool Node) using Straming replication with load balancing 4 DB nodes (1Master and 3 Slaves). Versions: 1. postgres: 9.5.15 2.

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

2020-04-02 Thread Tejaswini GC
Hello Julien, Thanks for your inputs, I shall get back to you If some information is needed. *Regards* *Tejaswini G C* *IT Retail Team* On Thu, Apr 2, 2020 at 4:35 PM Julien Rouhaud wrote: > Please don't top-post, it makes it hard to follow the discussion. > > On Thu, Apr 02, 2020 at

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

2020-04-02 Thread Julien Rouhaud
Please don't top-post, it makes it hard to follow the discussion. On Thu, Apr 02, 2020 at 03:52:56PM +0530, Tejaswini GC wrote: > > I'm in touch with our hosting team to get more information for your queries. > As of now I can share these details. > We did analyze on the DB, but not the vacuum,

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

2020-04-02 Thread Tejaswini GC
Hello Julien, Thanks for your response. I'm in touch with our hosting team to get more information for your queries. As of now I can share these details. We did analyze on the DB, but not the vacuum, We are using AWS RDS. Please help me with these queries as well. 1) Will the process change if

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

2020-04-02 Thread Julien Rouhaud
Hi, On Thu, Apr 02, 2020 at 03:52:25AM +, PG Bug reporting form wrote: > The following bug has been logged on the website: > > Bug reference: 16334 > Logged by: Tejaswini GC > Email address: tejaswini...@decathlon.com > PostgreSQL version: 10.10 > Operating system: