Nikolay Samokhvalov: Dump/restore done. Now what?
After pg_dump and pg_restore, by default the planner statistics and the visibility map are missing. One query: 32.6 s before VACUUM ANALYZE, 23 ms after.
Sources
- T2Nikolay Samokhvalov: Dump/restore done. Now what?Planet PostgreSQL