[OSM-dev] OSM2PGSQL in slim mode

[Frederik Ramm]

Hi,

   in addition to what Christian said:

On 20.01.2014 14:19, Amir Pourabdollah wrote:
> 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. 

I take it you are applying updates to the database. Is it possible that
you initially imported only an extract - e.g. just the UK - and are now
applying world-wide updates which would make your database grow much
quicker than the UK data set alone?

Other than that, if you have enough disk space, you *can* also make a
new import into a differently-named database and then just rename it
after you're done which would lead to just a minimal service interruption.

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00'09" E008°23'33"