Date: Tue, 6 Sep 2005 14:32:21 -0400
To: pgsql-sql@postgresql.org
Subject: Re: Performance issue
Message-ID: <20050906183221.GO5338@dba6.int.libertyrms.com>
Mail-Followup-To: pgsql-sql@postgresql.org
References: <20050830083855.DF6BBD83FB@svr1.postgresql.org>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="QRo3kt64Wi40AlcO"
Content-Disposition: inline
In-Reply-To: <20050830083855.DF6BBD83FB@svr1.postgresql.org>
User-Agent: Mutt/1.5.10i
From: tgoodair@ca.afilias.info (Tim Goodaire)


--QRo3kt64Wi40AlcO
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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.=20
>=20
> I wonder why now my web very slow to retrieve and display data?=20
> 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.=20
>=20
> 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

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

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

--QRo3kt64Wi40AlcO
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDHeC1W1uYbjhxf+0RAq0eAJ45mLC5ZDvGpwErd+iW5ki1RoJDiACfRY8A
kDKOktic5GbptvxN+fmuVaY=
=eyb5
-----END PGP SIGNATURE-----

--QRo3kt64Wi40AlcO--