Re: Re: How to track number of connections and hosts to Postgres cluster

On Tue, Aug 30, 2011 at 12:55 AM, Venkat Balaji <venkat(dot)balaji(at)verse(dot)in> wrote:
> Thanks to all for your very helpful replies !
> As Greg Smith rightly said, i faced a problem of missing connections between
> the runs. I even ran the cron every less than a second, but, still that
> would become too many runs per second and later i need to take the burden of
> calculating every thing from the log.
> I did not really calculate the IO load while the logging is on. I would
> switch on "log_connections" and "log_disconnections" to log the number of
> connections and duration of a connection.

yet another reason why we need connection and disconnection triggers
(especially the former, since disconnection triggers can be kludged
with an on_proc_exit/dblink hook).

merlin