[postgis-users] Does dump/restore lose CLUSTER?
Frederik Ramm
frederik at remote.org
Mon May 7 02:25:14 PDT 2012
Hi,
if I have a database clustered on a GIST index, and subsequently
transmit it to another machine using pg_dump/pg_restore, will I have to
repeat the CLUSTER command, or is the dump/restore process likely to use
the "on disk order" so that the resulting database will be more or less
clustered even without?
This is for a 500 GB table of linestring geometries on PostGIS
2.0/PostgreSQL 9.1.
Bye
Frederik
--
Frederik Ramm ## eMail frederik at remote.org ## N49°00'09" E008°23'33"
More information about the postgis-users
mailing list