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 frede...@remote.org  ##  N49°00'09" E008°23'33"
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to