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
