Date: Tue, 30 Aug 2005 06:34:14 -0600
From: Michael Fuhr <mike@fuhr.org>
To: Ricky Sutanto <ricky.sutanto@gmail.com>
Cc: Pgsql-sql@postgresql.org
Subject: Re: Performance issue
Message-ID: <20050830123414.GB36757@winnie.fuhr.org>
References: <43141be5.4f371831.1898.6e6f@mx.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <43141be5.4f371831.1898.6e6f@mx.gmail.com>

On Tue, Aug 30, 2005 at 03:42:06PM +0700, Ricky Sutanto wrote:
> I use Apache Web Server and PostgreSQL 7.3 to collect data everyday. Now it
> has been 5 month since I install that server. 

Which release of PostgreSQL 7.3?  What operating system and version?

> I wonder why now my web very slow to retrieve and display data? 

Are only web-based applications slow, or are the same queries issued
from another client (e.g., psql) also slow?  Are you running VACUUM
ANALYZE on a regular basis?  If not then you might have a lot of
dead tuples in your database.  In 7.3 you might also want to REINDEX
periodically (this isn't as necessary in later versions).  For more
information, see "Routine Database Maintenance Tasks" in the
documentation:

http://www.postgresql.org/docs/7.3/static/maintenance.html

If queries are still slow after database maintenance then please
post the EXPLAIN ANALYZE output of an example query.  Additional
info like table descriptions and sizes would also be helpful.

> 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. 

What client, and what do you mean by "seem not release after
allocate"?  What are you doing and how are you checking it?
What language are you using?

BTW, the pgsql-performance list would be more appropriate for
discussing performance issues.  Pgsql-sql is supposed to be for
SQL-related matters (how to write queries, etc.).

-- 
Michael Fuhr