Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 557092E005A for ; Wed, 21 May 2008 13:22:50 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 03514-08 for ; Wed, 21 May 2008 13:22:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mails1.interdominios.com (mails1.interdominios.com [89.248.97.42]) by developer.postgresql.org (Postfix) with ESMTP id A07CA2E004E for ; Wed, 21 May 2008 13:22:46 -0300 (ADT) Received: (qmail 9602 invoked from network); 21 May 2008 18:22:44 +0200 Received: from www.sedifa.com (HELO sardina) (83.175.220.10) by bloqmarine.com with SMTP; 21 May 2008 18:22:44 +0200 From: Albert Cervera Areny Organization: Sedifa, S.L. To: pgsql-performance@postgresql.org Subject: Re: Posible planner improvement? Date: Wed, 21 May 2008 18:22:42 +0200 User-Agent: KMail/1.9.9 References: <014F2941B0A1EA47BD61D21526B806E90162C3D2@MI8NYCMAIL08.Mi8.com> <48341F1D.3090304@archonet.com> In-Reply-To: <48341F1D.3090304@archonet.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200805211822.42528.albert@sedifa.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/299 X-Sequence-Number: 30267 A Dimecres 21 Maig 2008, Richard Huxton va escriure: > Luke Lonergan wrote: > > The problem is that the implied join predicate is not being > > propagated. This is definitely a planner deficiency. > > IIRC only equality conditions are propagated and gt, lt, between aren't. > I seem to remember that the argument given was that the cost of > checking for the ability to propagate was too high for the frequency > when it ocurred. > > Of course, what was true for code and machines of 5 years ago might not > be so today. Hope this can be revisited given the huge difference in this case: 80 minut= es=20 to 1 second. =2D-=20 Albert Cervera Areny Dept. Inform=C3=A0tica Sedifa, S.L. Av. Can Bordoll, 149 08202 - Sabadell (Barcelona) Tel. 93 715 51 11 =46ax. 93 715 51 12 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =2E....................... AVISO LEGAL ............................ La presente comunicaci=C3=B3n y sus anexos tiene como destinatario la persona a la que va dirigida, por lo que si usted lo recibe por error debe notificarlo al remitente y eliminarlo de su sistema, no pudiendo utilizarlo, total o parcialmente, para ning=C3=BAn fin. Su contenido puede tener informaci=C3=B3n confidencia= l o protegida legalmente y =C3=BAnicamente expresa la opini=C3=B3n = del remitente. El uso del correo electr=C3=B3nico v=C3=ADa Internet = no permite asegurar ni la confidencialidad de los mensajes ni su correcta recepci=C3=B3n. En el caso de que el destinatario no consintiera la utilizaci=C3=B3n del correo electr=C3=B3ni= co, deber=C3=A1 ponerlo en nuestro conocimiento inmediatamente. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =2E.......................... DISCLAIMER ............................. This message and its attachments are intended exclusively for the named addressee. If you receive this message in error, please immediately delete it from your system and notify the sender. You may not use this message or any part of it for any purpose. The message may contain information that is confidential or protected by law, and any opinions expressed are those of the individual sender. Internet e-mail guarantees neither the confidentiality nor the proper receipt of the message sent. If the addressee of this message does not consent to the use of internet e-mail, please inform us inmmediately. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =20