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 EBA06D1C50C for ; Fri, 1 Aug 2003 21:27:12 +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 71879-08 for ; Fri, 1 Aug 2003 18:26:06 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id CAD2ED1C4DB for ; Fri, 1 Aug 2003 18:27:10 -0300 (ADT) Received: from dev6.int.libertyrms.com ([10.1.2.212] helo=libertyrms.info) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19ihQb-0003kl-00; Fri, 01 Aug 2003 17:27:09 -0400 Received: by libertyrms.info (Postfix, from userid 1079) id E8875BBAD8; Fri, 1 Aug 2003 17:27:08 -0400 (EDT) To: "Fernando Papa" Cc: pgsql-performance@postgresql.org Subject: Re: I can't wait too much: Total runtime 432478.44 msec From: Christopher Browne Date: Fri, 01 Aug 2003 17:27:08 -0400 Message-ID: <60u191jcgj.fsf@dev6.int.libertyrms.info> User-Agent: Gnus/5.1003 (Gnus v5.10.3) XEmacs/21.4 (Rational FORTRAN, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/19 X-Sequence-Number: 2836 I'd point at the following as being a sterling candidate for being a cause of this being slow... =A0AND cont_publicacion.fecha_publicacion =3D (SELECT max(cp1.fecha_publica= cion)=20 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 FROM cont_publicacion c= p1=A0=20 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 WHERE cp1.id_instalacio= n =3D cont_publicacion.id_instalacion=20 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 AND cp1.id_conten= ido =3D cont_publicacion.id_contenido=A0=20 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 AND cp1.generar_v= ainilla =3D cont_publicacion.generar_vainilla)=A0=A0=A0=A0=20 May I suggest changing it to: =A0AND cont_publicacion.fecha_publicacion =3D (SELECT cp1.fecha_publicacion =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 FROM cont_publicacion c= p1=A0=20 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 WHERE cp1.id_instalacio= n =3D cont_publicacion.id_instalacion=20 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 AND cp1.id_conten= ido =3D cont_publicacion.id_contenido=A0=20 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 AND cp1.generar_v= ainilla =3D cont_publicacion.generar_vainilla ORDER BY fecha_publicacion LIMIT 1) That would get rid of the aggregate that's sitting deep in the query. --=20 select 'cbbrowne' || '@' || 'libertyrms.info'; Christopher Browne (416) 646 3304 x124 (land)