Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 20 Apr 2006 16:03:58 +0200
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."
- References:
- Identical query on two machines, different plans....
- From: Mario Splivalo
- Re: Identical query on two machines, different plans....
- From: Csaba Nagy
- Identical query on two machines, different plans....
- Prev by Date: Re: Identical query on two machines, different plans....
- Next by Date: Re: Identical query on two machines, different plans....
- Previous by thread: Re: Identical query on two machines, different plans....
- Next by thread: Re: Identical query on two machines, different plans....
- Indexes: