Re: How to keep queries low latency as concurrency increases - Mailing list pgsql-performance

From Marko Kreen
Subject Re: How to keep queries low latency as concurrency increases
Date
Msg-id CACMqXCLHjddYi91QiT9bki9vhvQFHd-bVXSR5+yoWTZuo8pPNA@mail.gmail.com
Whole thread Raw
In response to Re: How to keep queries low latency as concurrency increases  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: How to keep queries low latency as concurrency increases  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
On Sun, Nov 4, 2012 at 1:53 AM, Jeff Janes <jeff.janes@gmail.com> wrote:
> On a 4 CPU machine, if I run pgbench -c10 -j10 with dummy queries
> (like "select 1;" or "set timezone...") against 2 instances of
> pgbouncer, I get nearly twice the throughput as if I use only one
> instance.
>
> A rather odd workload, maybe, but it does seem to be similar to the
> one that started this thread.

Every-connection-is-busy is pessimal workload for pgbouncer,
as it has nothing useful to contribute to setup, just overhead.

--
marko


pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: How to keep queries low latency as concurrency increases
Next
From: Jeff Janes
Date:
Subject: Re: How to keep queries low latency as concurrency increases