Re: Advice/guideline on increasing shared_buffers and kernel parameters - Mailing list pgsql-admin

From Gnanakumar
Subject Re: Advice/guideline on increasing shared_buffers and kernel parameters
Date
Msg-id 001f01cd2dd0$4187f8d0$c497ea70$@com
Whole thread Raw
In response to Re: Advice/guideline on increasing shared_buffers and kernel parameters  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Advice/guideline on increasing shared_buffers and kernel parameters
List pgsql-admin
> We get very good performance dealing with
> thousands of concurrent users with a pool of 35 connections to the
> database.
>
> If you want to handle more users than you can currently support, you
> probably need to use fewer database connections.

First, please excuse me that I'm not able to understand this particular
point clearly. How can be reducing/using fewer connections in connection
pooler can support larger concurrent incoming connection requests?  If this
is so critical to revisit (reducing), then I may have to convince/justify my
peers also, before making this change in the Production server.  Can you
throw some light on this subject?

Thanks for bringing this idea to notice.



pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: increasing max_pred_locks_per_transaction, what shuold I look for?
Next
From: Chander Ganesan
Date:
Subject: pg_dump: schema with OID 2200 does not exist