[OSM-dev] OSM2PGSQL in slim mode

[Amir Pourabdollah]

Hi,
Many thanks for your comments.
Regarding vacuuming, the number of records are growing, not just the
database size.
Yes I apply updates on UK only. What I do is that I first apply the planet
update then remove the non-UK features from the ³main" tables, perhaps I
should remove the non-UK features from the temporary tables too(?)
Amir.

On 20/01/2014 21:00, "Frederik Ramm" <frederik at remote.org> wrote:

>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"
>
>_______________________________________________
>dev mailing list
>dev at openstreetmap.org
>https://lists.openstreetmap.org/listinfo/dev

This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.

This message has been checked for viruses but the contents of an attachment
may still contain software viruses which could damage your computer system, you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation.