dump/restore and statistics

Поиск
Список
Период
Сортировка
От Siberia
Тема dump/restore and statistics
Дата
Msg-id 1179720975.811605.219890@x35g2000prf.googlegroups.com
обсуждение исходный текст
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: camb
Дата:
Сообщение: Adding auto-increment / sequence
Следующее
От: Daniel Kastenholz
Дата:
Сообщение: Stored Procedures Performance: Java vs. PL/Pgsql