Pg max_connection

From: Nik Tek <niktek2005(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Pg max_connection
Date: 2013-06-18 17:49:19
Message-ID: CAHySzWUEhJti=093rfDthQi4Dnz+k4sQ9MyFuogb7pcwZNGTqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bambi Bellows 2013-06-18 17:53:03 Re: Pg max_connection
Previous Message Bruce Momjian 2013-06-17 23:08:03 Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."