Re: [HACKERS] keeping track of connections
Brett McCormick <brett@work.chicken.org>
From: Brett McCormick <brett@work.chicken.org>
To: The Hermit Hacker <scrappy@hub.org>
Cc: David Gould <dg@illustra.com>, Hal Snyder <hal@enteract.com>, pgsql-hackers@hub.org
Date: 1998-06-03T23:53:25Z
Lists: pgsql-hackers
On Wed, 3 June 1998, at 18:40:10, The Hermit Hacker wrote: > > > select * from procs; <stuff deleted> > > > > "procs" is a pseudo-table that is generated on the fly from the process > > data structures in the shared memory when queried. There are also > > pseudo-tables for locks and traces and other information. That's exactly what I envision. PRobably not what I articulated. > > The advantage of using SQL is that the data can be selected into other > > tables, grouped, projected, joined or whatever. The other advantage is > > that all the exiting clients can take advantage of the data. So if you > > wanted to write a graphical status monitor, you could do so quite simply > > in pgtcl. Exactly.