From: | "Angva" <angvaw(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump and cluster |
Date: | 2006-09-08 20:16:37 |
Message-ID: | 1157746597.127199.119900@b28g2000cwb.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I have a question regarding pg_dump and table clustering. Each night a
job runs that basically does the following:
1) load large amounts of data from flat files into a schema
2) cluster the data
3) pg_dump that schema
4) copy the resulting dmp to several destination databases
5) pg_restore the dmp on the destinations
Can anyone tell me if the restored data will remain clustered? That is,
does the dmp contain the data in clustered order, and if so, does
pg_restore preserve this order? I would like to know whether there
should be a step 6) cluster the data on the destinations, or if it
would just be a waste of time. (I need the whole job to run as quickly
as possible.)
Thanks,
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Reyes | 2006-09-08 20:29:49 | Determining right size for max_fsm_pages on large setup? |
Previous Message | Karen Hill | 2006-09-08 18:57:54 | Stored Procedure performance / elegance question |