Re: [GENERAL] phantom backends

2006-02-24 Thread Christopher Browne
Oops! [EMAIL PROTECTED] ("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?

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[GENERAL] phantom backends

2006-02-24 Thread 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

---(end of broadcast)---
TIP 6: explain analyze is your friend