X-Original-To: pgsql-performance@postgresql.org
Received: from jester.inquent.com (unknown [216.208.117.7])
	by postgresql.org (Postfix) with ESMTP id 5A1EF476543
	for <pgsql-performance@postgresql.org>;
	Wed, 12 Mar 2003 16:46:08 -0500 (EST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by jester.inquent.com (8.12.6/8.12.6) with ESMTP id h2CLjqTw057551;
	Wed, 12 Mar 2003 16:45:53 -0500 (EST) (envelope-from rbt@rbt.ca)
Subject: Re: Postgresql  performance
From: Rod Taylor <rbt@rbt.ca>
To: Enix Empreendimentos e =?ISO-8859-1?Q?Constru=E7=F5es?= "Ltda."
	<contato@enix.com.br>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
In-Reply-To: <000701c2e8d8$95637b60$02ada8c0@enix>
References: <000701c2e8d8$95637b60$02ada8c0@enix>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-29YHuXkyj8AJWUHrVYwm"
Organization: 
Message-Id: <1047505552.55840.56.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.2 
Date: 12 Mar 2003 16:45:52 -0500
X-Archive-Number: 200303/83
X-Sequence-Number: 1381

--=-29YHuXkyj8AJWUHrVYwm
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

> Is the performance of the mentioned Postgresql version much slower than t=
he
> 7.3.1?

Somewhat, but not significantly.

Standard questions:

Have you run VACUUM?
Have you run ANALYZE?
What does EXPLAIN ANALYZE <query> output for the slow queries?

If performance is still poor after the first 2, send the results of
EXPLAIN here and we'll tell you which index you're missing ;)

--=20
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

--=-29YHuXkyj8AJWUHrVYwm
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (FreeBSD)

iD8DBQA+b6qP6DETLow6vwwRAr7CAJsGf2qKawsn3DQF0XcLsFR7YTgQ3ACeKk4D
gb3qpzwd1I2PEJc0pUObMD4=
=/DeV
-----END PGP SIGNATURE-----

--=-29YHuXkyj8AJWUHrVYwm--