[OSM-talk] labs.mc.com updates

[Robert (Jamie) Munro]

Christopher Schmidt wrote:
> On Mon, Dec 04, 2006 at 01:46:15AM +0100, Joerg Ostertag (OSM Munich/Germany) wrote:
>>> I also worked with jburgess to define a 'replace' functionality for the
>>> osm2pgsql translator, which would allow me to update the database
>>> directly without having to have 45 minutes of downtime between the `drop
>>> table` and `commit;` steps of the current SQL.
>> Just a dumb thought? What about creating a new database with another name, 
>> then when ready dropping the old one and renaming the new one?
> 
> Not a dumb thought at all. But the result of that is the same as the
> result of changing the first few lines of the osm2pgsql -- a usable
> database while you're replacing all the records in the database.  Using
> transactions just allows you to do it in a way that's all database
> friendly and so on :)

Of course the real solution is to process the changes in the RSS feed
every hour or something, rather than process global once a week.

Robert (Jamie) Munro

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 249 bytes
Desc: OpenPGP digital signature
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20061204/236cd059/attachment.pgp>