Thread: BUG #1506: too many postgres.exe processes on background

BUG #1506: too many postgres.exe processes on background

From
"Roberto"
Date:
The following bug has been logged online:

Bug reference:      1506
Logged by:          Roberto
Email address:      ralabiso@hotmail.com
PostgreSQL version: 801
Operating system:   Windows XP Professional
Description:        too many postgres.exe processes on background
Details:

When I start up Postgre (installed as service during startup) y always have
4 postgres.exe processes on background.
Without having local or remotes connections (like external clients or
applications)after a few minutes i got more than 30 postgres.exe pocesses in
memory (run by admin 0% CPU and 60K of memory usage)

If i leave my pc on for hours instead of minutes, i got more than 200
postgres.exe bck processes

Re: BUG #1506: too many postgres.exe processes on background

From
"Magnus Hagander"
Date:
> The following bug has been logged online:
>=20
> Bug reference:      1506
> Logged by:          Roberto
> Email address:      ralabiso@hotmail.com
> PostgreSQL version: 801
> Operating system:   Windows XP Professional
> Description:        too many postgres.exe processes on background
> Details:=20
>=20
> When I start up Postgre (installed as service during startup)=20
> y always have
> 4 postgres.exe processes on background.

This is normal. Postmaster, bgwriter, stats collector and stats
bufferer.

> Without having local or remotes connections (like external=20
> clients or applications)after a few minutes i got more than=20
> 30 postgres.exe pocesses in memory (run by admin 0% CPU and=20
> 60K of memory usage)
>=20
> If i leave my pc on for hours instead of minutes, i got more=20
> than 200 postgres.exe bck processes

You are sure there are no connections at all?
If you connect to the server with psql and do a "select * from
pg_stat_activity", do they show up?
Do you get anything in the log, either in the pg_log directory or in the
eventlog?

//Magnus