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 830FE40C1F0 for ; Sun, 30 Jan 2005 18:04:40 +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 57134-08 for ; Sun, 30 Jan 2005 18:04:36 +0000 (GMT) Received: from rediffmail.com (unknown [203.199.83.37]) by svr1.postgresql.org (Postfix) with SMTP id 10CB440C1E3 for ; Sun, 30 Jan 2005 18:02:40 +0000 (GMT) Received: (qmail 5303 invoked by uid 510); 30 Jan 2005 18:04:10 -0000 Date: 30 Jan 2005 18:04:10 -0000 Message-ID: <20050130180410.5302.qmail@webmail27.rediffmail.com> Received: from unknown (202.88.246.214) by rediffmail.com via HTTP; 30 jan 2005 18:04:08 -0000 MIME-Version: 1.0 From: "N S" Reply-To: "N S" To: pgsql-performance@postgresql.org Subject: Re: Postgres server getting slow!! Content-type: multipart/alternative; boundary="Next_1107108248---0-203.199.83.37-5205" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.201 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_20_30, HTML_MESSAGE, MSGID_FROM_MTA_HEADER X-Spam-Level: * X-Archive-Number: 200501/622 X-Sequence-Number: 10312 This is a multipart mime message --Next_1107108248---0-203.199.83.37-5205 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I checked to find out the cause of the problem, ppp is disconnecting proper= ly and the user session is also closed smoothely.=0ABut when a report query= is run on the table containing 32500 records,=0Athe memory shoots up from = 50 MB to 500 MB(Total memory is 512 MB RAM).=0AAfter that the memory usage = never comes down .When some 4 or 5 user =0Aconnects, the remaining memory i= s utilised in a very little way, and finally the 6th or 7th user is denied = with database access.The server now becomes slow. =0A=0AWill running vacuum= help to solve the problem?=0A=0AThe total database dump is 50 MB and the /= var/lib/pgsql/data contains=0A700 MB of data.=0A=0A Which all paramters are= required to be increased in postgresq.conf.=0A=0A=0ARegds=0A=0AN S =0A=0AO= n Sun, 30 Jan 2005 N S wrote :=0A>=0A>=0A>Thanks tom. I checked the client = side software. The software closes connection when connected locally. But w= hen connected through dialup,=0A>this problem comes. I will check the ppp c= onnection also.=0A>Is there any method of killing old pids. And also any pe= rformance tuning to be done on postgresql.conf file.=0A>=0A>The database no= w contains 20K records. Will that cause a problem?=0A>=0A>Regds=0A>=0A>Nar= ayanan=0A>=0A>On Sat, 29 Jan 2005 Tom Lane wrote :=0A> >"Narayanan Subraman= iam Iyer" writes:=0A> > > 1) When 3 or 4 clients con= nect to this server, the pids are created and=0A> > > those pids are not ki= lled even after the client disconnects.=0A> >=0A> >In that case your client= s are not really disconnecting. Take a closer=0A> >look at your client-sid= e software.=0A> >=0A> > regards, tom lane=0A> >=0A> >-------------------= --------(end of broadcast)---------------------------=0A> >TIP 3: if postin= g/reading through Usenet, please send an appropriate=0A> > subscribe-= nomail command to majordomo@postgresql.org so that your=0A> > message= can get through to the mailing list cleanly=0A --Next_1107108248---0-203.199.83.37-5205 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

=0AI checked to find out the cause of the problem, ppp is disconnecting = properly and the user session is also closed smoothely.
=0ABut when a re= port query is run on the table containing 32500 records,
=0Athe memory s= hoots up from 50 MB to 500 MB(Total memory is 512 MB RAM).
=0AAfter that= the memory usage never comes down .When some 4 or 5 user
=0Aconnects, = the remaining memory is utilised in a very little way, and finally the 6th = or 7th user is denied with database access.The server now becomes slow. =0A
=0AWill running vacuum help to solve the problem?
=0A
=0AThe = total database dump is 50 MB and the /var/lib/pgsql/data contains
=0A700= MB of data.
=0A
=0A Which all paramters are required to be increased= in postgresq.conf.
=0A
=0A
=0ARegds
=0A
=0AN S
=0A
= =0AOn Sun, 30 Jan 2005 N S wrote :
=0A>
=0A>
=0A>Thanks t= om. I checked the client side software. The software closes connection when= connected locally. But when connected through dialup,
=0A>this probl= em comes. I will check the ppp connection also.
=0A>Is there any meth= od of killing old pids. And also any performance tuning to be done on postg= resql.conf file.
=0A>
=0A>The database now contains 20K records= . Will that cause  a problem?
=0A>
=0A>Regds
=0A>=0A>Narayanan
=0A>
=0A>On Sat, 29 Jan 2005 Tom Lane wrote :=
=0A> >"Narayanan Subramaniam Iyer" <bunix@rediffmail= .com> writes:
=0A> > > 1) When 3 or 4 clients connect to thi= s server, the pids are created and
=0A> > > those pids are not = killed even after the client disconnects.
=0A> >
=0A> >In= that case your clients are not really disconnecting.  Take a closer=0A> >look at your client-side software.
=0A> >
=0A>= >                regards, = tom lane
=0A> >
=0A> >---------------------------(end of = broadcast)---------------------------
=0A> >TIP 3: if posting/read= ing through Usenet, please send an appropriate
=0A> >   =   subscribe-nomail command to majordomo@postgresql.org so that your<= BR>=0A> >      message can get through to the mailing= list cleanly
=0A=0A

=0A

=0A=0A --Next_1107108248---0-203.199.83.37-5205--