[Dbmail] 2.0.6+ DB Keepalive

2005-09-19 Thread Niblett, David A
Paul, I believe you mentioned that in 2.0.6 and above, dbmail now opens a new connection to the database every second to make sure that it's alive rather than using the pgstatus function. (for PostgreSQL) I was wondering what the reason for that change is? I've noticed that now if I look at a ne

Re: [Dbmail] 2.0.6+ DB Keepalive

2005-09-19 Thread Paul J Stevens
Niblett, David A wrote: > Paul, > > I believe you mentioned that in 2.0.6 and above, dbmail now > opens a new connection to the database every second to make > sure that it's alive rather than using the pgstatus function. > (for PostgreSQL) before 2.0.6 it called db_connect/db_disconnect every

RE: [Dbmail] 2.0.6+ DB Keepalive

2005-09-19 Thread Niblett, David A
Ok, so now it's using Pgstatus, interesting. Any thoughts on why I see so many TIME_WAIT connections to my database? I have usually around 150-170 at all times. My timeout is the Linux default of 4 min. Am I just the lucky one, or do others see this? I'm using 2.0.6 on a Linux Gentoo box, kern