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