[plt-scheme] concurrent database connections

From: YC (yinso.chen at gmail.com)
Date: Fri Mar 27 17:30:53 EDT 2009

On Thu, Mar 26, 2009 at 8:35 AM, Dave Gurnell <d.j.gurnell at gmail.com> wrote:

>
> A single connection will presumably make the site slow under load.
>
> I think the default non-superuser concurrent connection limit in PostgreSQL
> is 100. We use the dumb policy of one connection per request (put the
> connection in a thread-cell and connect/disconnect using dynamic-wind) and
> we've never hit it. We've run "stress tests" with 50 machines performing >1
> request/second. It's not massive by Google's standards but it's more than
> enough for us.
>

Yeah psql's default is 100.  It sounds like your production environment has
only a single web frontend at this time, is that correct?

Thanks,
yc
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.racket-lang.org/users/archive/attachments/20090327/f8544ad2/attachment.html>

Posted on the users mailing list.