Thread: pg_dump and cluster

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

Angva wrote:
> 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?

Yes.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Thanks Alvaro!