Re: [HACKERS] stats for network traffic WIP

2013-12-09 Thread Nigel Heron
On Sat, Dec 7, 2013 at 1:17 PM, Fujii Masao wrote: > > Could you share the performance numbers? I'm really concerned about > the performance overhead caused by this patch. > I've tried pgbench in select mode with small data sets to avoid disk io and didn't see any difference. That was on my old c

Re: [HACKERS] review: autovacuum_work_mem

2013-11-20 Thread Nigel Heron
On Mon, Nov 18, 2013 at 11:36 PM, Peter Geoghegan wrote: > Please reply to the original thread in future (even if the Reply-to > Message-ID is the same, I see this as a separate thread). > sorry about that, when i added "review" to the subject gmail removed the thread info. for reference the origi

Re: [HACKERS] review: autovacuum_work_mem

2013-11-15 Thread Nigel Heron
On Sun, Oct 20, 2013 at 7:21 AM, Magnus Hagander wrote: > On Sun, Oct 20, 2013 at 2:22 AM, Peter Geoghegan wrote: >> It seemed neater to me to create a new flag, so that in principle any >> vacuum() code path can request autovacuum_work_mem, rather than having >> lazyvacuum.c code call IsAutoVac

Re: [HACKERS] Can we add sample systemd service file to git repo?

2013-11-12 Thread Nigel Heron
On Tue, Nov 12, 2013 at 11:47 AM, Devrim GÜNDÜZ wrote: > > Hi, > > Many distros are switching/switched to systemd. In the git repo, we only > have init script for SysV. Would it make sense to add systemd service > script to our tarball as well? This could also standardize the systemd > scripts use

Re: [HACKERS] stats for network traffic WIP

2013-11-11 Thread Nigel Heron
On Thu, Nov 7, 2013 at 8:21 PM, Greg Stark wrote: > > > The most interesting thing that I could see calculating from these stats > would require also knowing how much time was spent waiting on writes and > reads on the network. With the cumulative time spent as well as the count of > syscalls you

Re: [HACKERS] stats for network traffic WIP

2013-11-08 Thread Nigel Heron
On Tue, Oct 29, 2013 at 11:26 AM, Nigel Heron wrote: >> >> So, for now, the counters only track sockets created from an inbound >> (client to server) connection. > > here's v3 of the patch (rebase and cleanup). > Hi, here's v4 of the patch. I added docum

Re: [HACKERS] stats for network traffic WIP

2013-10-29 Thread Nigel Heron
> > So, for now, the counters only track sockets created from an inbound > (client to server) connection. here's v3 of the patch (rebase and cleanup). -nigel. *** a/src/backend/catalog/system_views.sql --- b/src/backend/catalog/system_views.sql *** *** 586,592 CREATE VIEW pg_stat

Re: [HACKERS] stats for network traffic WIP

2013-10-23 Thread Nigel Heron
On Wed, Oct 23, 2013 at 2:44 PM, Nigel Heron wrote: > Hi, thanks, I'm still actively working on this patch. I've gotten the > traffic counters working when using SSL enabled clients (includes the > ssl overhead now) but I still have the walsender transfers under SSL > to w

Re: [HACKERS] stats for network traffic WIP

2013-10-23 Thread Nigel Heron
On Wed, Oct 23, 2013 at 2:58 PM, Atri Sharma wrote: > On Thu, Oct 24, 2013 at 12:23 AM, Mike Blackwell > 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 e

Re: [HACKERS] stats for network traffic WIP

2013-10-23 Thread Nigel Heron
__ > Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management > | RR Donnelley > 1750 Wallace Ave | St Charles, IL 60174-3401 > Office: 630.313.7818 > mike.blackw...@rrd.com > http://www.rrdonnelley.com > > > > > On Mon, Oct 21, 2013

[HACKERS] stats for network traffic WIP

2013-10-20 Thread Nigel Heron
Hi, I've been using postgres for many years but never took the time to play with the code until now. As a learning experience i came up with this WIP patch to keep track of the # of bytes sent and received by the server over it's communication sockets. Counters are kept per database, per connection