Re: scaling up postgres

From: David Boreham <david_list(at)boreham(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: scaling up postgres
Date: 2006-06-03 15:18:46
Message-ID: 4481A856.7050907@boreham.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Lane wrote:

>fzied(at)planet(dot)tn writes:
>
>
>>I'm using httperf/autobench for measurments and the best result I can get
>>is that my system can handle a trafiic of almost 1600 New con/sec.
>>
>>
>
>As per PFC's comment, if connections/sec is a bottleneck for you then
>the answer is to use persistent connections. Launching a new backend
>is a fairly heavyweight operation in Postgres.
>
I thought the OP was talking about HTTP connections/s. He didn't say if he
was using persistent database connections or not (obviously better if so).
If it were the case that his setup is new backend launch rate-limited, then
wouldn't the machine show CPU saturation ? (he said it didn't).

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Saunders 2006-06-03 15:35:54 Re: scaling up postgres
Previous Message Tom Lane 2006-06-03 15:12:38 Re: scaling up postgres