| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Venkat Balaji <venkat(dot)balaji(at)verse(dot)in> |
| Cc: | Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>, Guillaume Lelarge <guillaume(at)lelarge(dot)info>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: How to track number of connections and hosts to Postgres cluster |
| Date: | 2011-08-24 18:23:14 |
| Message-ID: | CAOR=d=1bFv=Yw5QbWSV9KnSFo1wnbehLi7ymGjeHUqVvgx9SAw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Aug 24, 2011 at 5:21 AM, Venkat Balaji <venkat(dot)balaji(at)verse(dot)in> wrote:
> But, the information vanishes if the application logs off.
> I am looking for an alternative to track the total amount of the connections
> with the host IPs through a Cron job.
> What could be the frequency of cron ?
> I know the best is using log_connections and log_disconnections parameters,
> but, information logged would be too high and is also IO intensive.
Really? Have you tested how much IO it will generate? My guess is
not that much. And on a database server it should be a miniscule
amount compared to what your DB is doing the rest of the time.
Eliminating this choice is premature optimization IMHO.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2011-08-24 18:27:30 | Re: Intel 320 SSD info |
| Previous Message | gnuoytr | 2011-08-24 17:46:10 | Re: Intel 320 SSD info |