[OSM-dev] Speeding up Osm2pgsql through parallelization?
Martijn van O
kleptog at gmail.com
Sun Sep 18 12:47:53 BST 2011
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/
More information about the dev
mailing list