On Tue, 8 Feb 2005 13:44:48 -0800 (PST), CSN <cool_screen_name90001@xxxxxxxxx> wrote: > > --- Lonni J Friedman <netllama@xxxxxxxxx> wrote: > > > On Tue, 8 Feb 2005 13:17:38 -0800 (PST), CSN > > <cool_screen_name90001@xxxxxxxxx> wrote: > > > Is this anything to worry about? Why are there so > > many > > > Postgresql connections? 'ps axu' usually only > > shows > > > about 5-10 postgres processes. > > > > > > # netstat > > > tcp 0 0 localhost.localdo:55547 > > > localhost.loca:postgres TIME_WAIT > > > tcp 0 0 localhost.localdo:55780 > > > localhost.loca:postgres ESTABLISHED > > > tcp 0 0 localhost.localdo:55777 > > > localhost.loca:postgres ESTABLISHED > > > tcp 0 0 localhost.localdo:55778 > > > localhost.loca:postgres ESTABLISHED > > > tcp 0 0 localhost.localdo:55779 > > > localhost.loca:postgres ESTABLISHED > > > tcp 0 0 localhost.localdo:55764 > > > localhost.loca:postgres TIME_WAIT > > > tcp 0 0 localhost.localdo:55760 > > > localhost.loca:postgres TIME_WAIT > > > tcp 0 0 localhost.localdo:55566 > > > localhost.loca:postgres TIME_WAIT > > > tcp 0 0 localhost.localdo:55567 > > > localhost.loca:postgres TIME_WAIT > > > tcp 0 0 localhost.localdo:55562 > > > localhost.loca:postgres TIME_WAIT > > > tcp 0 0 localhost.localdo:55567 > > > localhost.loca:postgres TIME_WAIT > > > tcp 0 0 localhost.localdo:55562 > > > localhost.loca:postgres TIME_WAIT > > > tcp 0 0 localhost.localdo:55563 > > > localhost.loca:postgres TIME_WAIT > > > tcp 0 0 localhost.loca:postgres > > > localhost.localdo:55780 ESTABLISHED > > > tcp 47 0 localhost.loca:postgres > > > localhost.localdo:55783 ESTABLISHED > > > tcp 42 0 localhost.loca:postgres > > > localhost.localdo:55782 ESTABLISHED > > > tcp 0 0 localhost.loca:postgres > > > localhost.localdo:55777 ESTABLISHED > > > tcp 0 0 localhost.loca:postgres > > > localhost.localdo:55779 ESTABLISHED > > > tcp 31 0 localhost.loca:postgres > > > localhost.localdo:55785 ESTABLISHED > > > tcp 47 0 localhost.loca:postgres > > > localhost.localdo:55784 ESTABLISHED > > > > > > > The vast majority of these are in a TIME_WAIT state, > > where the socket > > is waiting after close to handle packets still in > > the network. What > > do you have accessing this DB? > > It's a web server (Apache and PHP). > OK, then that looks fairly normal assuming that you have a decent amount of traffic. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@xxxxxxxxx LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
