| From: | Rob Audenaerde <Rob(dot)Audenaerde(at)Valuecare(dot)nl> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | migrating statistics without data? |
| Date: | 2011-11-14 16:53:06 |
| Message-ID: | 1D020918205F334CBDD5CE7DF2038A2E15A81E7ED7@IE2RD2XVS271.red002.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi all,
I am migrating a database with tables that contain over 5M rows. These tables are truncated and filled each day in a batch process. There are scripts that simply don't run within 24hrs if the statistics are incorrect.
The current procedure is to run the process until it fails, then analyse all the tables that are filled sofar, and redo the batch. (As you can see the batch is not a transaction, but rather a set of scripts that follow each other in their own transactions.
My path of thought was to find a way to transfer the statistics somehow.
Is there a way to transfer the statistics of the old database to the new one, so we can reuse the statistics? Or is there a better alternative to achieve the same?
Kind regards,
-Rob
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cédric Villemain | 2011-11-14 17:01:13 | Re: rsync and streaming replication |
| Previous Message | Manoj K P | 2011-11-14 09:54:52 | Database corruption |