Re: How to keep queries low latency as concurrency increases

From: Marko Kreen <markokr(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, Catalin Iacob <iacobcatalin(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: How to keep queries low latency as concurrency increases
Date: 2012-11-05 22:58:34
Message-ID: CACMqXCLHjddYi91QiT9bki9vhvQFHd-bVXSR5+yoWTZuo8pPNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sun, Nov 4, 2012 at 1:53 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2012-11-05 23:31:52 Re: How to keep queries low latency as concurrency increases
Previous Message Merlin Moncure 2012-11-05 22:51:44 Re: How to keep queries low latency as concurrency increases