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 16D99D1B8FC
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sat, 30 Aug 2003 02:49:31 +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 85323-03
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 29 Aug 2003 23:49:04 -0300 (ADT)
Received: from wolff.to (wolff.to [66.93.249.74])
	by svr1.postgresql.org (Postfix) with SMTP id 5D902D1B897
	for <pgsql-performance@postgresql.org>;
	Fri, 29 Aug 2003 23:48:59 -0300 (ADT)
Received: (qmail 30723 invoked by uid 500); 30 Aug 2003 02:55:03 -0000
Date: Fri, 29 Aug 2003 21:55:03 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: Ken Geis <kgeis@speakeasy.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: bad estimates
Message-ID: <20030830025503.GA30691@wolff.to>
Mail-Followup-To: Ken Geis <kgeis@speakeasy.org>,
	pgsql-performance@postgresql.org
References: <20030829025109.GD4373@wolff.to> <3F4EBF7E.8020602@speakeasy.org>
	<20030829030156.GF4373@wolff.to> <3F4EC1D0.5010503@speakeasy.org>
	<20030829033818.GA5577@wolff.to> <3F4ECC78.7090502@speakeasy.org>
	<20030829040519.GA5746@wolff.to> <3F4ED1DC.50808@speakeasy.org>
	<20030829042453.GA5931@wolff.to> <3F4F0777.8090503@speakeasy.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <3F4F0777.8090503@speakeasy.org>
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/518
X-Sequence-Number: 3334

I haven't come up with any great ideas for this one. It might be interesting
to compare the explain analyze output from the distinct on query with
and without seqscans enabled.