Обсуждение: dump/restore and statistics

Поиск
Список
Период
Сортировка

dump/restore and statistics

От
Siberia
Дата:
Dear PostgreSQL deverlopers !

Why PostgreSQL do not export statistics equally with common data?
So, during pg_restore it'll feed database with the right statistics...

Users required to make time-consuming analyze on a whole database
right after restore of the database.

Another way to skip this unnecessary step - is to calculate
statistics
during importing data from dump file.

So, it is easy to implement method 1 or method 2 to skip analyzing
whole
database after import. Hope this helps make PG better.

Best wishes,
Ruslan