Re: could not fork new process for connection: Resource temporarily unavailable

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Jimit Amin <jimitamin9(at)gmail(dot)com>, Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: could not fork new process for connection: Resource temporarily unavailable
Date: 2015-07-04 19:26:12
Message-ID: 55983354.6010503@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 07/04/2015 12:19 PM, Jimit Amin wrote:
> ello,
>
> I have heavy transaction load production database 9.3 PPAS .Today
> Database is not able to give new process. I checked pg_stat_activity ,
> there are so many transaction in waiting stage because of one procedure
> and lock on one table (Code inside procedure)

PPAS is not a postgresql project. I would suggest you contact EnterpriseDB.

Sincerely,

JD

--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Vanasco 2015-07-04 20:30:04 trouble converting several serial queries into a parallel query
Previous Message Jimit Amin 2015-07-04 19:19:40 could not fork new process for connection: Resource temporarily unavailable