From: Greg Williamson <gwilliamson39@yahoo.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: How to keep queries low latency as concurrency increases
Date: Tue, 30 Oct 2012 15:11:54 -0700 (PDT)
Message-ID: <1351635114.18993.YahooMailNeo@web125906.mail.ne1.yahoo.com> (raw)
In-Reply-To: <CAMkU=1zq_pOG19tdq0UGoCNr71ojw5RpqUXXAjwR-K83J9zdTA@mail.gmail.com>
References: <CAHg_5goaCywcDuZ7+ko-H7g3Aia4EUrw+Vm1EiVO+EunFn8mog@mail.gmail.com>
<CAMkU=1zq_pOG19tdq0UGoCNr71ojw5RpqUXXAjwR-K83J9zdTA@mail.gmail.com>
Jeff / Catalin --
Jeff Janes wrote:
>On Mon, Oct 29, 2012 at 5:11 PM, Catalin Iacob <iacobcatalin@gmail.com> wrote:
>
>> pgbouncer 1.4.2 installed from Ubuntu's packages on the same machine
>> as Postgres. Django connects via TCP/IP to pgbouncer (it does one
>> connection and one transaction per request) and pgbouncer keeps
>> connections open to Postgres via Unix socket.
>
>Isn't pgbouncer single-threaded?
>
>If you hitting it with tiny queries as fast as possible from 20
>connections, I would think that it would become the bottleneck.
>
>Cheers,
>
I'm sure pgbouncer has some threshold where it breaks down, but we have servers (postgres 8.4 and 9.1) with connections from runtime (fed via haproxy) to pgbouncer that routinely have tens of thousands of connections in but only 40-70 postgres connections to the postgres cluster itself. Mix of queries but most are simple. Typically a few thousand queries a second to the readonly boxes, about the same to a beefier read / write master.
This is a slightly old pgbouncer at that ... used is a fairly basic mode.
Greg Williamson
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gwilliamson39@yahoo.com
Subject: Re: How to keep queries low latency as concurrency increases
In-Reply-To: <1351635114.18993.YahooMailNeo@web125906.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox