Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Greg Stark <gsstark(at)mit(dot)edu> writes:
>
> The estimated row counts for the bottom-level scans show some
> differences, which probably account for the differing choice of plans.
>
> Are these actually the same data with up-to-date ANALYZE stats in both
> cases? I do not recall that we've made any adjustments to the basic
> statistical estimation routines since 7.3 ...
The exact same data. I just copied the data using pg_dumpall to do the upgrade
and haven't updated either database at all since. The analyze stats should be
pretty up-to-date but in any case should be the same for both assuming they
get copied in the dump as well.
--
greg