Francisco Reyes wrote:
Ever since I installed a particular program, PHPWiki, I am seeing idle
postgres sessions.. even days old. Is it safe to delete them?
For example:
postmaster: wiki simplicato_wiki [local] idle (postgres)
Ultimately I will either switch wiki or take the time and find the piece
of code that is causing the sessions to remain open, but until then
don't want to leave those idle sessions around.. for days.
At a guess, PHPWiki is using persistent connections to PG, so you'll get
one connection per Apache backend. If you reduce the number of idle
Apache backends you should reduce the number of idle PG connections too.
Alternatively, a small change in PHPWiki's code should clear it too
(start with a search for pg_pconnect and try pg_connect instead).
It's perfectly safe to leave the idle connections there - they won't
take up much in the way of resources.
HTH
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
