On 14 September 2011 09:54, Hartmut Holzgraefe <[email protected]> wrote: > i've been wondering about that, too, but after reading the full manual > section on CLUSTER to its end i found that the tmp->sort->overwrite > way is actually recommended for large tables that are too large to fit > into RAM. > > See http://www.postgresql.org/docs/9.0/static/sql-cluster.html
FWIW, since 9.1 this is no longer true: http://www.postgresql.org/docs/9.1/static/release-9-1.html E.1.3.5.4. CLUSTER * Allow CLUSTER to sort the table rather than scanning the index when it seems likely to be cheaper (Leonardo Francalanci) Have a nice day, -- Martijn van Oosterhout <[email protected]> http://svana.org/kleptog/ _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
