X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id BEACED1B8B3 for ; Mon, 1 Sep 2003 12:11:57 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 37020-02 for ; Mon, 1 Sep 2003 09:11:50 -0300 (ADT) Received: from mailer.acaso.net (209.Red-213-97-17.pooles.rima-tde.net [213.97.17.209]) by svr1.postgresql.org (Postfix) with ESMTP id DE131D1B8AE for ; Mon, 1 Sep 2003 09:11:45 -0300 (ADT) Received: from 6-allhosts (unknown [192.168.0.4]) by mailer.acaso.net (Postfix) with ESMTP id EFFD41015D; Mon, 1 Sep 2003 14:11:40 +0200 (CEST) Subject: Re: SQL performance problems From: Alberto Caso To: Rhaoni Chiu Pereira Cc: PostgreSQL Performance In-Reply-To: <1062368198.1052.34.camel@localhost> References: <1062190759.3f4fbea7aae8c@sistemica.info> <1062368198.1052.34.camel@localhost> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-YE2S/jCV08aArwkGM1gr" Organization: Adaptia Soluciones Integrales Message-Id: <1062418299.1052.246.camel@localhost> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Mon, 01 Sep 2003 14:11:40 +0200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/1 X-Sequence-Number: 3367 --=-YE2S/jCV08aArwkGM1gr Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Mon, 01-09-2003 at 13:42, Rhaoni Chiu Pereira wrote:=20 > I've done that but it didn't make much difference. > Do you know some documentation on explain ? I don't understand the result= s.. >=20 http://developer.postgresql.org/docs/postgres/sql-explain.html http://developer.postgresql.org/docs/postgres/performance-tips.html Also this list's archives (which can be found at http://archives.postgresql.org/pgsql-performance/ ) are a good source of info on the subject. Best Regards, --=20 Alberto Caso Palomino Adaptia Soluciones Integrales http://www.adaptia.net alberto.caso@adaptia.net --=-YE2S/jCV08aArwkGM1gr Content-Type: application/pgp-signature; name=signature.asc Content-Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmada digitalmente -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQA/Uzd6/tUyzpgV/S0RAlvpAJ4m2ySz1sew8Kf3PBfzvKmBPtkOCACfbk3D w1q7hJ2Sxe3G36/NkQjdpYY= =abfm -----END PGP SIGNATURE----- --=-YE2S/jCV08aArwkGM1gr--