X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 7DA80924E57 for ; Tue, 20 May 2003 12:31:39 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 12807-09 for ; Tue, 20 May 2003 12:31:28 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by developer.postgresql.org (Postfix) with ESMTP id D6A40924E66 for ; Tue, 20 May 2003 12:31:27 -0400 (EDT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3049776; Tue, 20 May 2003 09:31:29 -0700 Content-Type: text/plain; charset="koi8-r" From: Josh Berkus Organization: Aglio Database Solutions To: Victor Yegorov , Eugene Fokin Subject: Re: 7.3.2 vs 7.1.2 Date: Tue, 20 May 2003 09:30:20 -0700 User-Agent: KMail/1.4.3 Cc: pgsql-performance@postgresql.org References: <20030520122838.GA28654@solvo.ru> <20030520132842.GA29262@solvo.ru> <20030520140713.GN1976@nordlb.lv> In-Reply-To: <20030520140713.GN1976@nordlb.lv> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200305200930.20233.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/199 X-Sequence-Number: 1978 Eugene, > 7.2.1 "... rows=147281 width=4) ..." > 7.3.2 "... rows=147281 width=181) ..." Unless we have a serious bug here, Victor changed the definition of his index, or of his table, between versions. Or mabye type casting during upgade changed it? Please post the definition of "loads" and " load_rcn_id_idx" in each system, Victor. Intentionally or not, you changed it between systems. -- Josh Berkus Aglio Database Solutions San Francisco