Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id A20C247614E; Tue,  7 Jan 2003 11:30:16 -0500 (EST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP
	id 23CE24771B4; Tue,  7 Jan 2003 11:29:48 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h07GTm0U013844;
	Tue, 7 Jan 2003 11:29:48 -0500 (EST)
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>,
	pgsql-performance@postgresql.org, pgsql-general@postgresql.org,
	pgsql-sql@postgresql.org
Subject: Re: [SQL] [PERFORM] 7.3.1 index use / performance 
In-reply-to: <Pine.LNX.4.44.0301071754580.8183-200000@matrix.gatewaynet.com> 
References: <Pine.LNX.4.44.0301071754580.8183-200000@matrix.gatewaynet.com>
Comments: In-reply-to Achilleus Mantzios <achill@matrix.gatewaynet.com>
	message dated "Tue, 07 Jan 2003 18:27:32 -0200"
Date: Tue, 07 Jan 2003 11:29:48 -0500
Message-ID: <13843.1041956988@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/237
X-Sequence-Number: 35358

Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> About the stats on these 3 columns i get:

Does 7.2 generate the same stats?  (minus the schemaname of course)

Also, I would like to see the results of these queries on both versions,
so that we can see what the planner thinks the index selectivity is:

EXPLAIN ANALYZE select * from noon where
v_code='4500';

EXPLAIN ANALYZE select * from noon where
report_date between '2002-01-07' and '2003-01-07';

			regards, tom lane