On Sun, 2005-04-10 at 07:54 -0700, pankaj naug wrote:
> [quoting Tom]
> >Evidently one has been analyzed much more recently than the other,
> because the estimated row counts are wildly different.
>
> Both the explain/analyse queries has been run at the same time.
in that case, is the data the same?
if so, what about STATISTICS settings for relevant columns?
just to make things clear, have both databases have been
ANALYZEd or VACUUM ANALYZEd recently ? (in case your
'explain/analyse' only refers to a EXPLAIN ANALYZE)
gnari