Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Miernik <public(at)public(dot)miernik(dot)name>
Cc: pgsql-performance(at)postgresql(dot)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: 2008-07-31 15:30:35
Message-ID: 4891DA9B.3010808@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew T. O'Connor 2008-07-31 17:45:38 SSD Performance Article
Previous Message Craig Ringer 2008-07-31 10:24:32 Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence