Re: [PERFORM] Identical query on two machines, different plans....

2006-04-20 Thread Csaba Nagy
OK, I marked the wrong row counts, but the conclusion is the same. Cheers, Csaba. > > QUERY PLAN > > --- > > Index Scan using ticketing_codes_uq_value_

Re: [PERFORM] Identical query on two machines, different plans....

2006-04-20 Thread Mario Splivalo
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... Th

Re: [PERFORM] Identical query on two machines, different plans....

2006-04-20 Thread Csaba Nagy
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. > QUERY PLAN >