Pg max_connection - Mailing list pgsql-admin

From Nik Tek
Subject Pg max_connection
Date
Msg-id CAHySzWUEhJti=093rfDthQi4Dnz+k4sQ9MyFuogb7pcwZNGTqA@mail.gmail.com
Whole thread Raw
Responses Re: Pg max_connection  (Bambi Bellows <bbellows@dotomi.com>)
List pgsql-admin
Hi,

I have a question on max_connections.

I have a application which would require more connection at the startup time(something like 500 connections), after the initial startup is done, the connections drop to 50.

Question: If I set my max_connection to 500 at the db start-up time and later after 1 hour the application drops the db connections to 50. Would this have any impact on the resource usage and performance?

Is this normal?

Thank you
Nik

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
Next
From: Bambi Bellows
Date:
Subject: Re: Pg max_connection