Обсуждение: lingering processes
i am testing pgsql (beta 2). is it normal to have a bunch of lingering processes: 15180 p0- I 0:00.71 /usr/local/bin/postmaster (postgres) 15181 p0- I 0:00.01 postmaster: stats buffer process (postgres) 15183 p0- I 0:00.07 postmaster: stats collector process (postgres) 15298 p0- I 0:00.77 postmaster: web mnwork [local] idle (postgres) 15322 p0- S 0:00.65 postmaster: web mnwork [local] idle (postgres) 15929 p0- I 0:00.81 postmaster: web mnwork [local] idle (postgres) 16007 p0- S 0:01.39 postmaster: web mnwork [local] idle (postgres) 16008 p0- I 0:00.69 postmaster: web mnwork [local] idle (postgres) 16010 p0- I 0:00.94 postmaster: web mnwork [local] idle (postgres) 16011 p0- I 0:00.64 postmaster: web mnwork [local] idle (postgres) 16017 p0- I 0:01.09 postmaster: web mnwork [local] idle (postgres) 16094 p0- I 0:00.80 postmaster: web mnwork [local] idle (postgres) I'm testing it with PHP with persistent connections set to OFF.
"Thomas T. Thai" <tom@minnesota.com> writes: > i am testing pgsql (beta 2). is it normal to have a bunch of lingering > processes: > > 15180 p0- I 0:00.71 /usr/local/bin/postmaster (postgres) > 15181 p0- I 0:00.01 postmaster: stats buffer process (postgres) > 15183 p0- I 0:00.07 postmaster: stats collector process (postgres) > 15298 p0- I 0:00.77 postmaster: web mnwork [local] idle (postgres) > 15322 p0- S 0:00.65 postmaster: web mnwork [local] idle (postgres) > 15929 p0- I 0:00.81 postmaster: web mnwork [local] idle (postgres) > 16007 p0- S 0:01.39 postmaster: web mnwork [local] idle (postgres) > 16008 p0- I 0:00.69 postmaster: web mnwork [local] idle (postgres) > 16010 p0- I 0:00.94 postmaster: web mnwork [local] idle (postgres) > 16011 p0- I 0:00.64 postmaster: web mnwork [local] idle (postgres) > 16017 p0- I 0:01.09 postmaster: web mnwork [local] idle (postgres) > 16094 p0- I 0:00.80 postmaster: web mnwork [local] idle (postgres) > > I'm testing it with PHP with persistent connections set to OFF. Look at your 'netstat' output and see if the socket connections are still there. If so it's likely to be a PHP problem. -Doug -- Let us cross over the river, and rest under the shade of the trees. --T. J. Jackson, 1863
On 21 Nov 2001, Doug McNaught wrote: > "Thomas T. Thai" <tom@minnesota.com> writes: > > > i am testing pgsql (beta 2). is it normal to have a bunch of lingering > > processes: > > > > 15180 p0- I 0:00.71 /usr/local/bin/postmaster (postgres) > > 15181 p0- I 0:00.01 postmaster: stats buffer process (postgres) > > 15183 p0- I 0:00.07 postmaster: stats collector process (postgres) > > 15298 p0- I 0:00.77 postmaster: web mnwork [local] idle (postgres) > > 15322 p0- S 0:00.65 postmaster: web mnwork [local] idle (postgres) > > 15929 p0- I 0:00.81 postmaster: web mnwork [local] idle (postgres) > > 16007 p0- S 0:01.39 postmaster: web mnwork [local] idle (postgres) > > 16008 p0- I 0:00.69 postmaster: web mnwork [local] idle (postgres) > > 16010 p0- I 0:00.94 postmaster: web mnwork [local] idle (postgres) > > 16011 p0- I 0:00.64 postmaster: web mnwork [local] idle (postgres) > > 16017 p0- I 0:01.09 postmaster: web mnwork [local] idle (postgres) > > 16094 p0- I 0:00.80 postmaster: web mnwork [local] idle (postgres) > > > > I'm testing it with PHP with persistent connections set to OFF. > > Look at your 'netstat' output and see if the socket connections are > still there. If so it's likely to be a PHP problem. yes i see them in netstat. if persistent connecition are turned off, these should disappear right? anyone else having this problem with PHP4.0.6+ and lingering processes?