Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id D8B4B650370
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 31 Jul 2008 12:31:18 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 80657-04-5
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 31 Jul 2008 12:31:12 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from polaris.pinpointresearch.com
	(66-7-238-130.static-ip.telepacific.net [66.7.238.130])
	by postgresql.org (Postfix) with ESMTP id 3F82265022C
	for <pgsql-performance@postgresql.org>;
	Thu, 31 Jul 2008 12:30:40 -0300 (ADT)
Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com
	[192.168.1.179])
	by polaris.pinpointresearch.com (Postfix) with ESMTP id ECB61E00EC82;
	Thu, 31 Jul 2008 08:30:35 -0700 (PDT)
Message-ID: <4891DA9B.3010808@pinpointresearch.com>
Date: Thu, 31 Jul 2008 08:30:35 -0700
From: Steve Crawford <scrawford@pinpointresearch.com>
User-Agent: Thunderbird 2.0.0.14 (X11/20080502)
MIME-Version: 1.0
To: Miernik <public@public.miernik.name>
CC: pgsql-performance@postgresql.org
Subject: Re: how to fix problem then when two queries run at the
	same time, it takes longer to complete then if run in sequence
References: <20080723152112.30A4.0.NOFFLE@turbacz.local>
	<dcc563d10807231025s617c6b16neb93c6348a658cdb@mail.gmail.com>
	<20080723203203.31C4.0.NOFFLE@turbacz.local>
	<488840D3.2090808@archonet.com>
	<20080731061522.54FE.0.NOFFLE@turbacz.local>
In-Reply-To: <20080731061522.54FE.0.NOFFLE@turbacz.local>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200807/278
X-Sequence-Number: 30878


> Wanted to install pgbouncer, but it is broken currently in Debian. And
> why is it in contrib and not in main (speaking of Debian location)

Pgbouncer has worked very well for us. Wasn't available in default repos 
for Ubuntu server when I did my original setup but installing from 
source is quite easy. Running heavy load benchmarks on a web app 
(high-rate simple-queries) I saw about a 10-fold improvement just by 
using pgbouncer.

Cheers,
Steve