[OSM-dev] Speeding up Osm2pgsql through parallelization?

[Martijn van O]

On 14 September 2011 09:54, Hartmut Holzgraefe
<hartmut.holzgraefe at gmail.com> 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 <kleptog at gmail.com> http://svana.org/kleptog/