Re: how much does a connection cost?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Andy Kriger <akriger(at)greaterthanone(dot)com>
Cc: Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: how much does a connection cost?
Date: 2003-05-29 11:07:41
Message-ID: 20030529110741.GB11002@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 28, 2003 at 19:18:45 -0400,
Andy Kriger <akriger(at)greaterthanone(dot)com> wrote:
> The default config for max_connections is 32.
>
> We have a server where we host web applications, each with its own
> connection pool. For every additional webapp, I'm supposing that we are
> placing more and more demands on those 32 connections (dividing a fixed
> resource among increased clients).
>
> So, it would seem to make sense to increase the max_connections whenever a
> new webapp is created. However, what is the drawback to having more
> connections available? Is it memory? disk space? file handles? Is there a
> practical limit?

It shouldn't be based on the web apps as much as what the web server
needs. For example if you run apache using the prefork mpm, you will
want to make the number of allowed postgres connections greater than
the number of allowed apache processes.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pginfo 2003-05-29 11:17:59 URGENT: how to restore corrupted pg?
Previous Message Jean-Michel POURE 2003-05-29 10:41:36 pgAdmin3 snapshots