pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steve Crawford <scrawford@pinpointresearch.com>
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
Date: Thu, 31 Jul 2008 08:30:35 -0700
Message-ID: <4891DA9B.3010808@pinpointresearch.com> (raw)
In-Reply-To: <20080731061522.54FE.0.NOFFLE@turbacz.local>
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>


> 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




view thread (18+ messages)

Message-ID: <4891DA9B.3010808@pinpointresearch.com>
Permalink:  ../4891DA9B.3010808@pinpointresearch.com/
Also on:    postgresql.org/message-id/4891DA9B.3010808@pinpointresearch.com

 · 

reply

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: scrawford@pinpointresearch.com, public@public.miernik.name
  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
  In-Reply-To: <4891DA9B.3010808@pinpointresearch.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