Re: scaling up postgres - Mailing list pgsql-performance

From David Boreham
Subject Re: scaling up postgres
Date
Msg-id 4481A856.7050907@boreham.org
Whole thread Raw
In response to Re: scaling up postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: scaling up postgres
List pgsql-performance
Tom Lane wrote:
fzied@planet.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).


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: scaling up postgres
Next
From: "Neil Saunders"
Date:
Subject: Re: scaling up postgres