Re: Advice/guideline on increasing shared_buffers and kernel parameters

Поиск
Список
Период
Сортировка
От Gnanakumar
Тема Re: Advice/guideline on increasing shared_buffers and kernel parameters
Дата
Msg-id 001f01cd2dd0$4187f8d0$c497ea70$@com
обсуждение исходный текст
Ответ на Re: Advice/guideline on increasing shared_buffers and kernel parameters  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Advice/guideline on increasing shared_buffers and kernel parameters  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: increasing max_pred_locks_per_transaction, what shuold I look for?
Следующее
От: Chander Ganesan
Дата:
Сообщение: pg_dump: schema with OID 2200 does not exist