From: Mario Splivalo <mario.splivalo@mobart.hr>
To: Pgsql performance <pgsql-performance@postgresql.org>
Cc: Csaba Nagy <nagy@ecircle-ag.com>
Subject: Re: Identical query on two machines, different plans....
Date: Thu, 20 Apr 2006 16:03:58 +0200
Message-ID: <1145541838.9373.11.camel@localhost.localdomain> (raw)
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>
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."
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mario.splivalo@mobart.hr, nagy@ecircle-ag.com
Subject: Re: Identical query on two machines, different plans....
In-Reply-To: <1145541838.9373.11.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox