Tom,
> It's presumably dependent on the contents of pg_statistic and the
> relpages/reltuples counts in pg_class for the tables involved.
> You could likely reproduce it by migrating that data to your laptop.
> It would take a little bit of hacking to get the pg_statistic data
> in (adjusting starelid for instance) but I think it's doable.
>
> Note that the planner control settings (eg effective_cache_size) might
> also need to be copied.
Hmmm ... could I do it through a binary file copy? I'm on a bit of a
deadline here, and need to replace the bad view in the next hour or so.
--
-Josh Berkus
Aglio Database Solutions
San Francisco