pgBouncer for connection pooling
От | Kieren Scott |
---|---|
Тема | pgBouncer for connection pooling |
Дата | |
Msg-id | BAY149-w45AD2D7EB1BFEF71621197AE820@phx.gbl обсуждение исходный текст |
Ответы |
Re: pgBouncer for connection pooling
Re: pgBouncer for connection pooling Re: pgBouncer for connection pooling |
Список | pgsql-admin |
Hi,
I have a web-based application (drupal) which uses PHP to make connections to a back-end postgresql 8.3 server. The application and database are on separate servers, but as we can get 20+ concurrent connections on the database I've looked at pgBouncer to try and reduce the overhead of new connections on the database. I currently have pgBouncer running on the same server as my postgres database but I was wondering whether this is a recommended setup - are the performance benefits of using a connection pooler overshadowed by the overhead of running pgBouncer on the same server as the database?
How are other people using pgBouncer? E.g. on a separate server from the database etc...?
Thanks in advance.
I have a web-based application (drupal) which uses PHP to make connections to a back-end postgresql 8.3 server. The application and database are on separate servers, but as we can get 20+ concurrent connections on the database I've looked at pgBouncer to try and reduce the overhead of new connections on the database. I currently have pgBouncer running on the same server as my postgres database but I was wondering whether this is a recommended setup - are the performance benefits of using a connection pooler overshadowed by the overhead of running pgBouncer on the same server as the database?
How are other people using pgBouncer? E.g. on a separate server from the database etc...?
Thanks in advance.
В списке pgsql-admin по дате отправления: