Search Postgresql Archives

Re: Does idle sessions will consume more cpu and ram? If yes,how to control them

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Does idle sessions will consume more cpu and ram? If yes,how to control them
From: Joshua White <joshua.white@xxxxxxxxxx>
Date: Thu, 20 Dec 2018 11:32:22 +1100
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAEHH7R5wnqTJ3gxiBmVfQLk2CXa2k+xpq24Ma2edCaQm2jntbw@mail.gmail.com>
References: <CAEHH7R5wnqTJ3gxiBmVfQLk2CXa2k+xpq24Ma2edCaQm2jntbw@mail.gmail.com>

In my application, the idle sessions are consuming cpu and ram. refer the ps command output.

If you connect to the database, does select * from pg_stat_activity() show a lot of idle connections?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Does idle sessions will consume more cpu and ram? If yes,how to control them
  - From: Michael Paquier

References:
- Does idle sessions will consume more cpu and ram? If yes,how to control them
  - From: Raghavendra Rao J S V

Prev by Date: Re: new stored procedure with OUT parameters
Next by Date: Re: Does idle sessions will consume more cpu and ram? If yes,how to control them
Previous by thread: Does idle sessions will consume more cpu and ram? If yes,how to control them
Next by thread: Re: Does idle sessions will consume more cpu and ram? If yes,how to control them
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux