Re: [GENERAL] PGbouncer and batch vs real-time pools

2013-02-14 Thread Sergey Konoplev
On Thu, Feb 14, 2013 at 9:09 AM, François Beausoleil wrote: > I believe the important user is the one pgbouncer uses to connect to the real > PostgreSQL server. That user + dbname is what creates a new pool. The > client's name (the one the app connects as) is irrelevant since I hard-code > wha

[GENERAL] PGbouncer and batch vs real-time pools

2013-02-14 Thread François Beausoleil
Hello all, >From reading the PGbouncer configuration man page, PGbouncer creates a new >pool on every DB + user pair. If I have two types of queries, long-lived batch >reporting and fast PK lookups, then I should favor two pools. Both pools can >hit the same database server. I can configure pg