Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] keeping track of connections

From: Massimo Dal Zotto <dz(at)cs(dot)unitn(dot)it>
To: hackers(at)postgreSQL(dot)org (PostgreSQL Hackers)
Subject: Re: [HACKERS] keeping track of connections
Date: 1998-06-08 14:53:10
Message-ID: 199806081453.QAA02911@pennac.cs.unitn.it (view raw or flat)
Thread:
Lists: pgsql-hackers
> 
> Hi,
> 
> > On Wed, 3 June 1998, at 16:38:43, Ulrich Voss wrote:
> > 
> > > Massimo had a patch, which added the pid in the first field of the 
> > > debug output (and I guess a timestamp). So you can easily 
> > > sort/grep/trace the debug output. 
> > 
> > I'm looking for a little more than that.
> 
> OK, but step  one is simple, Massimo's patch could possibly be 
> integrated in two or three hours. And it adds valuable debugging 
> info.
> 
> (Btw., Massimo's patch was the first (and I hope last) very helpful 
> patch, which for obscure reasons never made into the official 
> distribution. And it had this simple pid/time patch (not in current 
> cvs), it had a spinlock patch (not in current cvs), a better deadlock 
> detection (than 6.2.1, not 6.3) and an async listen option (also the 
> 6.4. version will be much better I gues). That's why we still use 
> 6.2.1p6 + massimo patch).

Me too. I'm still using 6.2.1p6 because I didn't found the time to port all
the patches to 6.3. They are almost done except for the lock code which was
in the meantime modified by Bruce. I hope they will be available before 6.4.

> > > Perhaps this would help and should be really easy.
> > > 
> > > BTW., I think this feature is so neat, it should be integrated even 
> > > if it doesn't solve *your* problem ;-)
> > 
> > There isn't much of a problem, I just would love to have the feature I
> > mentioned.  What are you referring to, the above?
> 
> Yeah, fine. Monitoring the backend is wonderful, but the 
> pid/timestamp addition is simple and useful too. 
> 
> Thanks again for a great product!
> 
> Ulrich
> 
> 
> 
> Ulrich Voss                            \ \   / /__  / ___|__ _| |
> VoCal web publishing                    \ \ / / _ \| |   / _` | |
> voss(at)vocalweb(dot)de                         \ V / (_) | |__| (_| | |
> http://www.vocalweb.de                    \_/ \___/ \____\__,_|_|
> Tel: (++49) 203-306-1560                           web publishing
> 
> 
> 


-- 
Massimo Dal Zotto

+----------------------------------------------------------------------+
|  Massimo Dal Zotto                e-mail:  dz(at)cs(dot)unitn(dot)it            |
|  Via Marconi, 141                 phone:  ++39-461-534251            |
|  38057 Pergine Valsugana (TN)     www:  http://www.cs.unitn.it/~dz/  |
|  Italy                            pgp:  finger dz(at)tango(dot)cs(dot)unitn(dot)it  |
+----------------------------------------------------------------------+

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-06-08 15:16:20
Subject: Re: [HACKERS] Need some help on code
Previous:From: Alexzander BlashkoDate: 1998-06-08 13:03:09
Subject: Re: [HACKERS] CGI with lilbpq

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group