| From: | Siberia <Dautkhanov(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | dump/restore and statistics |
| Date: | 2007-05-21 04:16:15 |
| Message-ID: | 1179720975.811605.219890@x35g2000prf.googlegroups.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Conor McTernan | 2007-05-21 04:17:09 | User permissions/Data separation. |
| Previous Message | Tom Lane | 2007-05-21 03:43:26 | Re: Trigger function which inserts into table; values from lookup |