Stats collection on Windows

From: "Peter Brant" <Peter(dot)Brant(at)wicourts(dot)gov>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Stats collection on Windows
Date: 2006-04-05 00:35:30
Message-ID: 4432CA82020000BE00002949@gwmta.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

I think I've found the cause (or one of the causes) why stats
collection is unreliable on Windows and I'm wondering about the best way
to go about fixing it.

The problem is that process IDs on Windows seem to be assigned without
much rhyme or reason and it seems to happen relatively frequently that a
new process will be assigned the same process ID as a process which
recently died. If this happens before the backend has been expired out
of pgstat.c's pgStatBeDead hash, the backend will be missed.

I was thinking the postmaster could maintain a backend sequence number
with similar semantics to a UNIXish process ID which could then be used
as the key for pgStatBeDead instead of the actual process ID. Does that
sound reasonable?

Peter

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Glaesemann 2006-04-05 02:20:48 Re: Fixing domain input
Previous Message Luke Lonergan 2006-04-05 00:22:45 Re: I have changed employers