Re: Performance issue - Mailing list pgsql-sql

From tgoodair@ca.afilias.info (Tim Goodaire)
Subject Re: Performance issue
Date
Msg-id 20050906183221.GO5338@dba6.int.libertyrms.com
Whole thread Raw
In response to Performance issue  ("Ricky Sutanto" <ricky@connexiasolutions.com>)
List pgsql-sql
On Tue, Aug 30, 2005 at 03:38:52PM +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.
>
> 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

You haven't really provided much information on your problem. Are you
vacuuming regularly?

Tim

>
> Thanks anyway,
>
>
> Ricky Sutanto
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>

--
Tim Goodaire    416-673-4126    tgoodair@ca.afilias.info
Database Administrator, Afilias Canada Corp.

pgsql-sql by date:

Previous
From: "Mark A. Strivens"
Date:
Subject: Age in days
Next
From: Gnanavel S
Date:
Subject: Re: Age in days