On Windows XP, using Process Explorer with the lower pane showing Handles, not
all postgres.exe processes are including an "Event" type with a description of
what the process is doing.
At the moment, I have ten postgres processes shown as being at the bottom of
the tree, three of which do not have such descriptions.
The processes that do show an Event type handle show these names:
\BaseNamedObjects\pgident: postgres: wal writer process
\BaseNamedObjects\pgident: postgres: autovacuum launcher process
plus one per connection like:
\BaseNamedObjects\pgident: postgres: postgres mydatabase 127.0.0.1(1954) idle
Comparing the list of processes to those of 8.2, I suspect that the processes
missing this detail are the log writer (one of the processes does have a File
Handle on the log file), and the stats collector.
I have autovacuum enabled for 8.3rc1, and disabled for 8.2.
PostgreSQL is started as a service.
Stephen Denne
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal privilege. If it is not intended for you please advise by
reply immediately, destroy it and do not copy, disclose or use it in any way.
__________________________________________________________________
This email has been scanned by the DMZGlobal Business Quality
Electronic Messaging Suite.
Please see http://www.dmzglobal.com/services/bqem.htm for details.
__________________________________________________________________
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
