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

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: BUG #1506: too many postgres.exe processes on background
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE476989@algol.sollentuna.se
обсуждение исходный текст
Ответ на BUG #1506: too many postgres.exe processes on background  ("Roberto" <ralabiso@hotmail.com>)
Список pgsql-bugs
> 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #1497: Default permissions allow any user to create objects
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #1502: hash_seq_search might return removed entry