PGbouncer and batch vs real-time pools
От | François Beausoleil |
---|---|
Тема | PGbouncer and batch vs real-time pools |
Дата | |
Msg-id | 7D324F07-7473-453C-92A7-05A37D8E64E8@teksol.info обсуждение исходный текст |
Ответы |
Re: PGbouncer and batch vs real-time pools
|
Список | pgsql-general |
Hello all, From reading the PGbouncer configuration man page, PGbouncer creates a new pool on every DB + user pair. If I have two typesof queries, long-lived batch reporting and fast PK lookups, then I should favor two pools. Both pools can hit the samedatabase server. I can configure pgbouncer like this: [databases] batch = host=127.0.0.1 port=5432 user=batch dbname=app pool_size=M quick = host=127.0.0.1 port=5432 user=quick dbname=app pool_size=N I believe the important user is the one pgbouncer uses to connect to the real PostgreSQL server. That user + dbname is whatcreates a new pool. The client's name (the one the app connects as) is irrelevant since I hard-code what user I wantto use. Did I read the configuration manual right? Any advice from people "familiar with the matter"? Thanks! François Beausoleil
В списке pgsql-general по дате отправления: