X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id CB2AC924EEB for ; Wed, 21 May 2003 03:13:17 -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 20797-03 for ; Wed, 21 May 2003 03:12:45 -0400 (EDT) Received: from gate.solvo.ru (gate.solvo.ru [195.201.44.1]) by developer.postgresql.org (Postfix) with ESMTP id 19E889250B8 for ; Wed, 21 May 2003 03:12:34 -0400 (EDT) Received: from grace.solvo.ru (grace.solvo.ru [195.201.44.100]) by gate.solvo.ru (8.8.8/8.8.8) with ESMTP id LAA14948; Wed, 21 May 2003 11:11:29 +0400 Received: from grace.solvo.ru (localhost [127.0.0.1]) by grace.solvo.ru (8.12.8/8.12.8) with ESMTP id h4L7BTpD004901; Wed, 21 May 2003 11:11:29 +0400 Received: (from elf@localhost) by grace.solvo.ru (8.12.8/8.12.8/Submit) id h4L7BQ53004899; Wed, 21 May 2003 11:11:26 +0400 Date: Wed, 21 May 2003 11:11:25 +0400 From: Eugene Fokin To: Josh Berkus Cc: Victor Yegorov , pgsql-performance@postgresql.org Subject: Re: 7.3.2 vs 7.1.2 Message-ID: <20030521071125.GB4664@solvo.ru> References: <20030520122838.GA28654@solvo.ru> <20030520132842.GA29262@solvo.ru> <20030520140713.GN1976@nordlb.lv> <200305200930.20233.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200305200930.20233.josh@agliodbs.com> User-Agent: Mutt/1.4i X-Operating-System: Linux 2.4.19-1pe i686 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/205 X-Sequence-Number: 1984 On Tue, May 20, 2003 at 09:30:20AM -0700, Josh Berkus wrote: > > > 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. Nothing changed ! Believe me :-) Same dump file, same platform, even the same machine. I've post already necessary definitions. -- Eugene Fokin SOLVO Ltd. Company