X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7EA743A63D0 for ; Sat, 29 Jan 2005 14:41:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87062-03 for ; Sat, 29 Jan 2005 14:41:48 +0000 (GMT) Received: from rediffmail.com (unknown [203.199.83.28]) by svr1.postgresql.org (Postfix) with SMTP id 62C283A63C4 for ; Sat, 29 Jan 2005 14:41:49 +0000 (GMT) Received: (qmail 18502 invoked by uid 510); 29 Jan 2005 14:43:21 -0000 Date: 29 Jan 2005 14:43:21 -0000 Message-ID: <20050129144321.18501.qmail@webmail18.rediffmail.com> Received: from unknown (61.95.196.133) by rediffmail.com via HTTP; 29 jan 2005 14:43:16 -0000 MIME-Version: 1.0 From: "Narayanan Subramaniam Iyer" Reply-To: "Narayanan Subramaniam Iyer" To: pgsql-performance@postgresql.org Subject: Postgres server getting slow!! Content-type: multipart/alternative; boundary="Next_1107009796---0-203.199.83.28-18398" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.158 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_20_30, HTML_IMAGE_ONLY_16, HTML_MESSAGE, MSGID_FROM_MTA_HEADER X-Spam-Level: ** X-Archive-Number: 200501/607 X-Sequence-Number: 10297 This is a multipart mime message --Next_1107009796---0-203.199.83.28-18398 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline =A0=0AHi=0A=0A i am running a High availability Postgresql server on redh= at=0Alinux 9. I am using NFS mount of data directory from a shared storage.= The server was running without problems for last two =0Amonths. The server= is connected to a dialin router where all my company units dialin and upda= te the database. =0AConcurrently i have some 25 to 50 connections at peak h= ours. =0A=0AFollowing are the problems i am facing =0A=0A1) When 3 or 4 cli= ents connect to this server, the pids are created and=0Athose pids are not = killed even after the client disconnects.=0Aafter sometimes some 10 to 20 p= ids gets created and postgres reject client connections. =0A=0A2) After one= or two concurrent connections, the server slows down.=0AThe postmaster occ= upies more than 90% of the memory.=0A=0A3) Even when restarting server, aft= er one or two connection from clients, the pids start increasing automatica= lly to 10 or 13. This again slows down the server.=0A=0APlease help me to s= ort out this issue=0A=0AThanks in advance .=0A=0A=0ARegards=0A=0AN S --Next_1107009796---0-203.199.83.28-18398 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

=0A 
=0AHi
=0A
=0A  i am running a High availability= Postgresql server on redhat
=0Alinux 9. I am using NFS mount of data di= rectory from a shared storage. The server was running without problems for = last two
=0Amonths. The server is connected to a dialin router where al= l my company units dialin and update the database.
=0AConcurrently i ha= ve some 25 to 50 connections at peak hours.
=0A
=0AFollowing are the= problems i am facing
=0A
=0A1) When 3 or 4 clients connect to this = server, the pids are created and
=0Athose pids are not killed even after= the client disconnects.
=0Aafter sometimes some 10 to 20 pids gets crea= ted and postgres reject client connections.
=0A
=0A2) After one or t= wo concurrent connections, the server slows down.
=0AThe postmaster occu= pies more than 90% of the memory.
=0A
=0A3) Even when restarting serv= er, after one or two connection from clients, the pids start increasing aut= omatically to 10 or 13. This again slows down the server.
=0A
=0APlea= se help me to sort out this issue
=0A
=0AThanks in advance .
=0A=0A
=0ARegards
=0A
=0AN S=0A

=0A

=0A=0A --Next_1107009796---0-203.199.83.28-18398--