X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4C565D1BC59 for ; Sun, 18 Apr 2004 16:22:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 14908-09 for ; Sun, 18 Apr 2004 16:22:34 -0300 (ADT) Received: from web11.manitu.net (web11.manitu.net [217.11.48.111]) by svr1.postgresql.org (Postfix) with ESMTP id 2A049D1BB49 for ; Sun, 18 Apr 2004 16:22:32 -0300 (ADT) Received: from [192.168.0.1] (dsl-082-082-191-125.arcor-ip.net [82.82.191.125]) (authenticated) by web11.manitu.net (8.10.2-SOL3/8.10.2) with ESMTP id i3IJMMM04900; Sun, 18 Apr 2004 21:22:22 +0200 Subject: Re: sunquery and estimated rows From: Markus Bertheau To: Tom Lane Cc: Litao Wu , pgsql-performance@postgresql.org In-Reply-To: <3802.1082159101@sss.pgh.pa.us> References: <20040416214529.10468.qmail@web13125.mail.yahoo.com> <3802.1082159101@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8 Message-Id: <1082316145.2191.0.camel@yarrow.bertheau.de> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-1) Date: Sun, 18 Apr 2004 21:22:26 +0200 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/249 X-Sequence-Number: 6549 =D0=92 =D0=A1=D0=B1=D1=82, 17.04.2004, =D0=B2 01:45, Tom Lane =D0=BF=D0=B8= =D1=88=D0=B5=D1=82: > The planner sees that as "where scope =3D " > and falls back to a default estimate. It won't simplify a sub-select > to a constant. (Some people consider that a feature ;-).) Why? Thanks --=20 Markus Bertheau