Re: The black art of postgresql.conf tweaking

From: Michal Taborsky <michal(at)taborsky(dot)cz>
To: Paul Serby <paul(dot)serby(at)clockltd(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: The black art of postgresql.conf tweaking
Date: 2004-08-04 13:10:55
Message-ID: 4110E05F.9030404@taborsky.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Paul Serby wrote:

> Apache on the Web server can take up to 300 connections and PHP is using
> pg_pconnect

> max_connections = 300
> But Apache is still maxing out the non-super user connection limit.

Don't forget also that some connections are reserved for superusers
(usually 2), so if you want 300 users, you need to set max_connections
to 300 + superuser_reserved_connections.

--
Michal Taborsky
http://www.taborsky.cz

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-08-04 13:21:51 Re: [PERFORM] Tuning queries on large database
Previous Message Jeff 2004-08-04 13:02:20 Re: The black art of postgresql.conf tweaking