dump/restore and statistics - Mailing list pgsql-general

From Siberia
Subject dump/restore and statistics
Date
Msg-id 1179720975.811605.219890@x35g2000prf.googlegroups.com
Whole thread Raw
List 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 by date:

Previous
From: camb
Date:
Subject: Adding auto-increment / sequence
Next
From: Daniel Kastenholz
Date:
Subject: Stored Procedures Performance: Java vs. PL/Pgsql