[OSM-dev] osm2pgsql diff imports benchmarks

Simon Poole simon at poole.ch
Mon Mar 19 11:42:59 GMT 2012



Am 19.03.2012 12:37, schrieb Lynn W. Deffenbaugh (Mr):
> And should I be doing a periodic vaccuum to clean out accumulated
cruft? I was thinking that not too much in the osm planet would be
deleting, but maybe my assumption is incorrect?
>
Yes and yes.

osm2pgsql does not update rows, it deletes them and inserts the new
version. You really need to run vacuum at least once per week, probably
more right now.

Simon

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20120319/888661f6/attachment.html>


More information about the dev mailing list