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
(oneof 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
attachmentsis 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
BusinessQuality Electronic Messaging Suite.
Please see http://www.dmzglobal.com/services/bqem.htm for details.
__________________________________________________________________