From: | Nigel Heron <nheron(at)querymetrics(dot)com> |
---|---|
To: | Atri Sharma <atri(dot)jiit(at)gmail(dot)com> |
Cc: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, PgHacker <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: stats for network traffic WIP |
Date: | 2013-10-23 19:09:03 |
Message-ID: | CAHhq2wJHW_DeCGEkHP6BESxXDjjmM=eiNr5hBJdZg4gJ2dBFgA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Oct 23, 2013 at 2:58 PM, Atri Sharma <atri(dot)jiit(at)gmail(dot)com> wrote:
> On Thu, Oct 24, 2013 at 12:23 AM, Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> wrote:
>> Sounds good. I personally don't have any interest in log file i/o counters,
>> but that's just me. I wonder if stats collector counters might be useful...
>> I seem to recall an effort to improve that area. Maybe not enough use to
>> take the performance hit on a regular basis, though.
>>
>
>
> +1.
>
> I tend to be a bit touchy about any changes to code that runs
> frequently. We need to seriously test if the overhead added by this
> patch is worth it.
>
> IMO, the idea is pretty good. Its just that we need to do some wide
> spectrum performance testing. Thats only my thought though.
>
I didn't implement the code yet, but my impression is that since it
will be the stats collector gathering counters about itself there will
be very little overhead (no message passing, etc.) .. just a few int
calculations and storing a few more bytes in the global stats file.
The log file io tracking would generate some overhead though, similar
to network stats tracking.
I think the stats collector concerns voiced previously on the list
were more about per relation stats which creates alot of io on servers
with many tables. Adding global stats doesn't seem as bad to me.
-nigel.
From | Date | Subject | |
---|---|---|---|
Next Message | Atri Sharma | 2013-10-23 19:10:48 | Re: stats for network traffic WIP |
Previous Message | Mike Blackwell | 2013-10-23 19:00:51 | Re: stats for network traffic WIP |