[OSM-dev] OSM2PGSQL in slim mode

[Christian Quest]

2014/1/20 Amir Pourabdollah <Amir.Pourabdollah at nottingham.ac.uk>

> Hi OSM Dev,
>
> I have an OSM database in PostGIS updated daily using OSM2PGSQL in slim
> mode. As you know the two tables planet_osm_nodes and planet_osm_ways are
> acting as temporary tables for the update process however I noticed that
> their size are incremented every day, thus slowing down the process. My
> solution so far has been doing a normal (non-slim mode) run of OSM2PGSQL
> every few months so it refreshes everything but this method is not
> preferred since the system is not functioning during the execution. Any
> idea on how to clean the database without a fresh OSM2PGSQL run?
> Thanks,
> Amir.
>


These tables should get larger only because we have mode nodes and ways in
OSM.
If it gets larger than that, make sure autovacuum is set to on. It is
common practice to disable it during initial import, but should be set back
to on after the initial import.

-- 
Christian Quest - OpenStreetMap France
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20140120/5e52695b/attachment.html>