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 D5591D1BA52 for ; Mon, 23 Feb 2004 03:38:45 +0000 (GMT) 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 28797-10 for ; Sun, 22 Feb 2004 23:38:48 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 9DB5AD1BA48 for ; Sun, 22 Feb 2004 23:38:42 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1N3ce3B020485; Sun, 22 Feb 2004 22:38:40 -0500 (EST) To: siracusa@mindspring.com Cc: Postgres Performance Subject: Re: Column correlation drifts, index ignored again In-reply-to: References: Comments: In-reply-to John Siracusa message dated "Sun, 22 Feb 2004 19:09:07 -0500" Date: Sun, 22 Feb 2004 22:38:40 -0500 Message-ID: <20484.1077507520@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/260 X-Sequence-Number: 5784 John Siracusa writes: > Does the planner get estimates from both plans before deciding whether or > not to use the one that references the date index? The rowcount estimate is made prior to the plan cost estimate, much less the plan selection. So you'd see the same number either way. regards, tom lane