Re: scaling up postgres

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: fzied(at)planet(dot)tn
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: scaling up postgres
Date: 2006-06-03 15:12:38
Message-ID: 15971.1149347558@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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. It sounds like there
may be some system-level constraints affecting the process creation
rate as well, but it's silly to spend a lot of effort on this when
you can so easily go around the problem.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David Boreham 2006-06-03 15:18:46 Re: scaling up postgres
Previous Message David Boreham 2006-06-03 12:43:24 Re: scaling up postgres