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.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster