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 06339D1CA07 for ; Fri, 1 Aug 2003 21:32:56 +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 70608-10 for ; Fri, 1 Aug 2003 18:31:49 -0300 (ADT) Received: from davinci.ethosmedia.com (209-128-84-228.bayarea.net [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 04023D1C94D for ; Fri, 1 Aug 2003 18:32:53 -0300 (ADT) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3368907; Fri, 01 Aug 2003 14:33:16 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Christopher Browne , "Fernando Papa" Subject: Re: I can't wait too much: Total runtime 432478.44 msec Date: Fri, 1 Aug 2003 14:31:52 -0700 User-Agent: KMail/1.4.3 Cc: pgsql-performance@postgresql.org References: <60u191jcgj.fsf@dev6.int.libertyrms.info> In-Reply-To: <60u191jcgj.fsf@dev6.int.libertyrms.info> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200308011431.52677.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/20 X-Sequence-Number: 2837 Fernando, > AND cont_publicacion.fecha_publicacion =3D (SELECT max(cp1.fecha_publica= cion)=20 > FROM cont_publicacion cp1=20=20 > WHERE cp1.id_instalacion =3D cont_publicacion.id_instal= acion=20 > AND cp1.id_contenido =3D cont_publicacion.id_contenid= o=20=20 > AND cp1.generar_vainilla =3D=20 cont_publicacion.generar_vainilla)=20=20=20=20=20 Or event changing it to: AND EXISTS (SELECT max(cp1.fecha_publicacion) FROM cont_publicacion cp1 WHERE cp1.id_instalacion =3D cont_publicacion.id_instalacion=20 AND cp1.id_contenido =3D cont_publicacion.id_contenido=20=20 AND cp1.generar_vainilla =3D cont_publicacion.generar_vainilla HAVING max(cp1.fecha_publicacion) =3D cont_publicacion.fecha_publicacion) --=20 -Josh Berkus Aglio Database Solutions San Francisco