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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html