I just dumped and restored a rather large database, I upgraded from 7.2.x to 7.3.x. When I went to test my application against the new database, it was dog slow. It had all the indexes, and looked fine.

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?


Reply via email to