Then it dawned on me, Doh! ANALYZE!
Should pg_dump appened an ANALYZE for each table?
On small tables, this shouldn't take too long. On large tables, you're gonna have to do it anyway. I guess it could be an option as well.
It just seems like on of the tasks that is required for a "restored" database to work properly, and as such, should probably be specified in the backup procedure.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
