Re: The black art of postgresql.conf tweaking - Mailing list pgsql-performance

From Michal Taborsky
Subject Re: The black art of postgresql.conf tweaking
Date
Msg-id 4110E05F.9030404@taborsky.cz
Whole thread Raw
In response to The black art of postgresql.conf tweaking  (Paul Serby <paul.serby@clockltd.com>)
List 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


pgsql-performance by date:

Previous
From: Jeff
Date:
Subject: Re: The black art of postgresql.conf tweaking
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Tuning queries on large database