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 3042ED1B8C0 for ; Sun, 31 Aug 2003 22:16: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 74042-06 for ; Sun, 31 Aug 2003 19:16:48 -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 21B54D1B56B for ; Sun, 31 Aug 2003 19:16:44 -0300 (ADT) Received: from 6-allhosts (unknown [192.168.0.4]) by mailer.acaso.net (Postfix) with ESMTP id 33BD61014D; Mon, 1 Sep 2003 00:16:44 +0200 (CEST) Subject: Re: SQL performance problems From: Alberto Caso To: Rhaoni Chiu Pereira Cc: PostgreSQL Performance In-Reply-To: <1062190759.3f4fbea7aae8c@sistemica.info> References: <1062190759.3f4fbea7aae8c@sistemica.info> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-G8WSUG5iU/cnyxZPQWOJ" Organization: Adaptia Soluciones Integrales Message-Id: <1062368198.1052.34.camel@localhost> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Mon, 01 Sep 2003 00:16:38 +0200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/548 X-Sequence-Number: 3364 --=-G8WSUG5iU/cnyxZPQWOJ Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Hi, Estimated and actual rows differ a lot. Did you a VACUUM ANALYZE so that the optimizer could update its statistics? Also it would be great if you could provide more information, as your PostgreSQL version, your table and indexes descriptions, etc. Have a look at:=20 http://techdocs.postgresql.org/guides/SlowQueryPostingGuidelines Please excuse me if you have already done it. I had a quick look at the list's archives and didn't found it in your prior posts. Regards, --=20 Alberto Caso Palomino Adaptia Soluciones Integrales http://www.adaptia.net alberto.caso@adaptia.net --=-G8WSUG5iU/cnyxZPQWOJ 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/UnPF/tUyzpgV/S0RAuDDAKDKxaIxIcMQuPbN8sK2oUjL+n5VbgCgzxsc 32d+0QS50it9fBRp84TOgGg= =PABT -----END PGP SIGNATURE----- --=-G8WSUG5iU/cnyxZPQWOJ--