Received: from wallace.ece.rice.edu (root@wallace.ece.rice.edu [128.42.12.154]) by hub.org (8.9.2/8.9.1) with ESMTP id OAA23646 for ; Mon, 8 Mar 1999 14:53:09 -0500 (EST) (envelope-from reedstrm@wallace.ece.rice.edu) Received: by wallace.ece.rice.edu via sendmail from stdin id (Debian Smail3.2.0.101) for pgsql-sql@postgreSQL.org; Mon, 8 Mar 1999 13:53:02 -0600 (EST) Message-Id: From: reedstrm@wallace.ece.rice.edu (Ross J. Reedstrom) Subject: Re: [SQL] 6.4.x vs. 6.5 oddity In-Reply-To: <19990308192757.20501.qmail@desertmoon.com> from "pierre@desertmoon.com" at "Mar 8, 99 12:27:57 pm" To: pierre@desertmoon.com Date: Mon, 8 Mar 1999 13:53:02 -0600 (CST) Cc: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL39 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Pierre - Are you sure the databases are identical? Including indicies? The only significant difference I can see is the choice of index by the 6.5 plan for the scan on pcat: > V6.5 > Index Scan using pcat_dcat_id_idx on pcat c (cost=264.24 size=4465 width=4) > > V6.4 > Index Scan using pcat_prod_id_idx on pcat c (cost=2.00 size=4457 width=4) Strangely enough, the estimated total cost difference is about the same ratio. -- Ross J. Reedstrom, Ph.D., NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005