Re: Selecting RAM and CPU based on max_connections

2022-05-20 Thread Ganesh Korde
You may also need to tune shmmax and shmmin kernel parameters. Regards, Ganesh Korde. On Fri, 20 May 2022, 1:58 pm aditya desai, wrote: > Hi, > One of our applications needs 3000 max_connections to the database. > Connection pooler like pgbouncer or pgpool is not certified within the > organiza

Re: Selecting RAM and CPU based on max_connections

2022-05-20 Thread aditya desai
Thanks! I will run these suggestions with App team. On Fri, May 20, 2022 at 4:01 PM Laurenz Albe wrote: > On Fri, 2022-05-20 at 12:15 +0200, Andreas Kretschmer wrote: > > On 20 May 2022 10:27:50 CEST, aditya desai wrote: > > > One of our applications needs 3000 max_connections to the database.

Re: Array of integer indexed nested-loop semi join

2022-05-20 Thread Mickael van der Beek
Hello Jeff, Sorry for the delay, here are the EXPLAIN ANALYSE results for one single row in the inner-query: Nested Loop Semi Join (cost=1000993.81..10004731160.70 rows=536206 > width=28) (actual time=93765.182..93765.183 rows=0 loops=1) > Output: fu.w2_page_idxs > Join Filter: (fu.w2_pa

Re: Need help on Query Tunning and Not using the Index Scan

2022-05-20 Thread Laurenz Albe
On Fri, 2022-05-20 at 07:37 +, Kumar, Mukesh wrote: > We are facing an issue in running the query which takes at least 30 sec to > run in PostgreSQL. >   > We have tried to create the indexes and done the maintenance and still that > query is taking same time. >   > Below are the explain plan

Re: Selecting RAM and CPU based on max_connections

2022-05-20 Thread Laurenz Albe
On Fri, 2022-05-20 at 12:15 +0200, Andreas Kretschmer wrote: > On 20 May 2022 10:27:50 CEST, aditya desai wrote: > > One of our applications needs 3000 max_connections to the database. > > Connection pooler like pgbouncer or pgpool is not certified within the > > organization yet. So they are look

Re: Selecting RAM and CPU based on max_connections

2022-05-20 Thread Andreas Kretschmer
On 20 May 2022 10:27:50 CEST, aditya desai wrote: >Hi, >One of our applications needs 3000 max_connections to the database. >Connection pooler like pgbouncer or pgpool is not certified within the >organization yet. So they are looking for setting up high configuration >Hardware with CPU and Memory

Selecting RAM and CPU based on max_connections

2022-05-20 Thread aditya desai
Hi, One of our applications needs 3000 max_connections to the database. Connection pooler like pgbouncer or pgpool is not certified within the organization yet. So they are looking for setting up high configuration Hardware with CPU and Memory. Can someone advise how much memory and CPU they will n

Need help on Query Tunning and Not using the Index Scan

2022-05-20 Thread Kumar, Mukesh
Hi Team, We are facing an issue in running the query which takes at least 30 sec to run in PostgreSQL. We have tried to create the indexes and done the maintenance and still that query is taking same time. Below are the explain plan for the query. https://explain.depesz.com/s/sPo2#html We ha