pg_dump and cluster

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

Responses

Browse pgsql-general by date

  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