Josh Berkus <josh@agliodbs.com> writes: > Now, if you were offering us a patch to auto-populate the statistics as a > table is loaded, I'd be all for that.
Curiously enough, I was just thinking about that after reading Craig's post. autovacuum will do this, sort of, if it's turned on --- but its reaction time is measured in minutes typically so that may not be good enough. Another thing we've been beat up about in the past is that loading a pg_dump script doesn't ANALYZE the data afterward... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match