X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 46A6111F6CED for ; Thu, 20 Apr 2006 11:04:03 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.549 X-Spam-Level: X-Spam-Status: No, score=-2.549 required=5 tests=[AWL=0.050, BAYES_00=-2.599] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id xquA9c21Wqql for ; Thu, 20 Apr 2006 11:04:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pjetlic.mobart.hr (pjetlic.mobart.hr [80.80.51.10]) by postgresql.org (Postfix) with ESMTP id 532C011F6CC7 for ; Thu, 20 Apr 2006 11:03:58 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by pjetlic.mobart.hr (Postfix) with ESMTP id 591FC17ABC; Thu, 20 Apr 2006 16:03:59 +0200 (CEST) Received: from pjetlic.mobart.hr ([127.0.0.1]) by localhost (pjetlic [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 17218-05-3; Thu, 20 Apr 2006 16:03:59 +0200 (CEST) Received: from mike.mobart.hr (mike.mobart.hr [192.168.10.94]) (using SSLv3 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by pjetlic.mobart.hr (Postfix) with ESMTP id 41B3217AB8; Thu, 20 Apr 2006 16:03:59 +0200 (CEST) Subject: Re: Identical query on two machines, different plans.... From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: Pgsql performance Cc: Csaba Nagy In-Reply-To: <1145541587.3553.30.camel@coppola.muc.ecircle.de> References: <1145541113.9373.9.camel@localhost.localdomain> <1145541587.3553.30.camel@coppola.muc.ecircle.de> Content-Type: text/plain Organization: Mob-Art Date: Thu, 20 Apr 2006 16:03:58 +0200 Message-Id: <1145541838.9373.11.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by OpenSource AV+AS Mail Server X-Archive-Number: 200604/445 X-Sequence-Number: 18529 On Thu, 2006-04-20 at 15:59 +0200, Csaba Nagy wrote: > You very likely forgot to run ANALYZE on your laptop after copying the > data. Observe the different row count estimates in the 2 plans... > > HTH, > Csaba. Sometimes I wish I am Dumbo the Elephant, so I could cover myself with me ears... Thnx :) Mike -- Mario Splivalo Mob-Art mario.splivalo@mobart.hr "I can do it quick, I can do it cheap, I can do it well. Pick any two."