X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 2CBA0D83C1
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 30 Aug 2005 05:42:18 -0300 (ADT)
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 66295-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 30 Aug 2005 08:42:13 +0000 (GMT)
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.195])
	by svr1.postgresql.org (Postfix) with ESMTP id 9DAF6D83B6
	for <Pgsql-sql@postgresql.org>; Tue, 30 Aug 2005 05:42:11 -0300 (ADT)
Received: by zproxy.gmail.com with SMTP id z6so736334nzd
	for <Pgsql-sql@postgresql.org>; Tue, 30 Aug 2005 01:42:13 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:reply-to:from:to:subject:date:organization:mime-version:content-type:content-transfer-encoding:x-mailer:x-mimeole:thread-index:message-id;
	b=fUP5abXYEYdhsYtIDgtv+SZchkMLKdRa5Vhgi8bWPsF0l33k2xk3weIYYMTpNs7ByVjngLxa6VM/iCBoAI9bO74G4+3Yad9//y1vGB0tEOzzPsVykDgh18cvovNDOvSVvz53tMgRDHHC826q5ybLBVM5vrL6B0Shug1yf4ZIqtk=
Received: by 10.36.39.2 with SMTP id m2mr680208nzm;
	Tue, 30 Aug 2005 01:42:13 -0700 (PDT)
Received: from nebulla ( [222.124.55.34])
	by mx.gmail.com with ESMTP id r1sm1077011nzd.2005.08.30.01.42.08;
	Tue, 30 Aug 2005 01:42:13 -0700 (PDT)
Reply-To: <ricky.sutanto@gmail.com>
From: "Ricky Sutanto" <ricky.sutanto@gmail.com>
To: <Pgsql-sql@postgresql.org>
Subject: Performance issue
Date: Tue, 30 Aug 2005 15:42:06 +0700
Organization: PT Connexia Makmur Jaya
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Thread-Index: AcWtDG12nKr7beQERq+Ykifq4cTdowAMi//Q
Message-ID: <43141be5.4f371831.1898.6e6f@mx.gmail.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.024 required=5 tests=[AWL=0.000, RCVD_BY_IP=0.024]
X-Spam-Level: 
X-Archive-Number: 200508/275
X-Sequence-Number: 22503


I use Apache Web Server and PostgreSQL 7.3 to collect data everyday. Now it
has been 5 month since I install that server. 

I wonder why now my web very slow to retrieve and display data? 
When I check the memory, I found that postgreSQL client seem not release
after allocate. I try to find bug on my script, but everything look clean to
me. 

Anyone have experience like me.. please share info with me

Thanks anyway, 


Ricky Sutanto