Re: Identical query on two machines, different plans.... - Mailing list pgsql-performance

From Mario Splivalo
Subject Re: Identical query on two machines, different plans....
Date
Msg-id 1145541838.9373.11.camel@localhost.localdomain
Whole thread Raw
In response to Re: Identical query on two machines, different plans....  (Csaba Nagy <nagy@ecircle-ag.com>)
List 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.splivalo@mobart.hr

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



pgsql-performance by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Identical query on two machines, different plans....
Next
From: Csaba Nagy
Date:
Subject: Re: Identical query on two machines, different plans....