Hi, I have a table that I am clustering on an index. I am then dumping that table via pg_dump –Fc and loading it into another database via pg_restore. It is unclear to me though if the clustering I did in the original database is preserved during the dump & restore or if I would still need to perform a CLUSTER again once the data was loaded into the new database. Can anyone confirm this? Cheers, Britt |
