Possible regression from PG10 to PG11 on windows

Started by Paul van der Lindenabout 7 years ago1 messagesbugs
Jump to latest
#1Paul van der Linden
paul.vanderlinden@mapcreator.eu

Hi,

I have a suspicion that since the upgrade of Postgres to 11 processes are not fully closed after their job is done.
The symptom I noticed IS that the process-ids are steadily increasing for new proccesses, they used to be in the 4-digit numbers with older Postgres versions, and now they are in the 6-digit range and still increasing.

It doesn't seem to have any other effects than that, but in theory it could run out of resources of some kind given enough time.

A possible cause of this could be that a handle to a finished backend-process isn't closed, and thus still hold a reference to that process (and prevent reuse of it's process-id).

Didn't investigate deeper yet, but perhaps this triggers someone's mind enough to know the cause/solution?

Paul