[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