On Tue, Aug 30, 2011 at 12:55 AM, Venkat Balaji <venkat.balaji@xxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
