Обсуждение: phantom backends

Поиск
Список
Период
Сортировка

phantom backends

От
"Ed L."
Дата:
I have a bunch of 7.4.6 backend processes that show up via
pg_stat_get_db_numbackends(), pg_stat_get_backend_idset(), etc,
but do not show up in ps.  Any clues?

Thanks,
Ed

Re: phantom backends

От
Christopher Browne
Дата:
Oops! pgsql@bluepolka.net ("Ed L.") was seen spray-painting on a wall:
> I have a bunch of 7.4.6 backend processes that show up via
> pg_stat_get_db_numbackends(), pg_stat_get_backend_idset(), etc,
> but do not show up in ps.  Any clues?

Possibly your statistics collector got "overrun," and the last time it
was successfully updated, they were there?
--
(reverse (concatenate 'string "moc.liamg" "@" "enworbbc"))
http://linuxdatabases.info/info/internet.html
If a man speaks in the forest and there is no woman to hear him, is he
still wrong?