Re: Identical query on two machines, different plans....

From: Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr>
To: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Cc: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Subject: Re: Identical query on two machines, different plans....
Date: 2006-04-20 14:03:58
Message-ID: 1145541838.9373.11.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(dot)splivalo(at)mobart(dot)hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Csaba Nagy 2006-04-20 14:06:11 Re: Identical query on two machines, different plans....
Previous Message Csaba Nagy 2006-04-20 13:59:48 Re: Identical query on two machines, different plans....