Re: [Potlatch-dev] [OpenStreetMap] #3472: Typing b when the background is OS locator should set source:name

2011-01-23 Thread OpenStreetMap
#3472: Typing b when the background is OS locator should set source:name --+- Reporter: Wynndale | Owner: potlatch-dev@… Type: enhancement | Status: closed

[OSM-dev] Patch to osm2pgsql for faster updates

2011-01-23 Thread Erik Burrows
Hi All, I was having great difficulty with applying the daily diffs to my PostgreSQL database (8.4 and 9.0). I would get good performance right after a vacuum, but after a few hours of updates, it would be running at less than real-time. After a great deal of experimentation, I found that the GIN

Re: [OSM-dev] Patch to osm2pgsql for faster updates

2011-01-23 Thread Erik Burrows
Corrected patch attached (without my custom change to default.style). Hi All, I was having great difficulty with applying the daily diffs to my PostgreSQL database (8.4 and 9.0). I would get good performance right after a vacuum, but after a few hours of updates, it would be running at less

Re: [OSM-dev] Patch to osm2pgsql for faster updates

2011-01-23 Thread Tom Hughes
On 23/01/11 16:24, Erik Burrows wrote: I was having great difficulty with applying the daily diffs to my PostgreSQL database (8.4 and 9.0). I would get good performance right after a vacuum, but after a few hours of updates, it would be running at less than real-time. After a great deal of

Re: [OSM-dev] Patch to osm2pgsql for faster updates

2011-01-23 Thread Lennard
On 23-1-2011 17:44, Tom Hughes wrote: On 23/01/11 16:24, Erik Burrows wrote: I was having great difficulty with applying the daily diffs to my PostgreSQL database (8.4 and 9.0). I would get good performance right [...] I wonder if in fact this is the performance problem that we saw using an

Re: [OSM-dev] Patch to osm2pgsql for faster updates

2011-01-23 Thread Erik Burrows
8.3 didn't have the fastupdate function at all, so I would imagine it is possible that the fastupdate introduction in 8.4 was the problem, since it is on by default in 8.4 and 9.0. I still have my 8.4 database, so I started it up and am re-creating the GIN indexes with fastupdate=off, to see if

Re: [OSM-dev] Patch to osm2pgsql for faster updates

2011-01-23 Thread Tom Hughes
On 23/01/11 17:13, Lennard wrote: On 23-1-2011 17:44, Tom Hughes wrote: On 23/01/11 16:24, Erik Burrows wrote: I was having great difficulty with applying the daily diffs to my PostgreSQL database (8.4 and 9.0). I would get good performance right [...] I wonder if in fact this is the

Re: [OSM-dev] Patch to osm2pgsql for faster updates

2011-01-23 Thread Philipp Borgers
Do we actually know that 9.0 is ok though? I was basing my comments on a single report of some preliminary tests at SOTM last year. Can someone explain the problem itself? We will set up our xapi database tomorrow and we would like to use 9.0. We can do some testing on 8.* and 9.* if you

Re: [OSM-dev] Patch to osm2pgsql for faster updates

2011-01-23 Thread Peter Körner
First import ist fast, index creation after it is normal. When the minutely updates start, they're fast at beginning but tend to get slower and slower until they get slower than realtime (eg. 5 minutes of changes take 10 minutes to import). In a normal setup, the diffs take around 1/2 the

Re: [OSM-dev] Patch to osm2pgsql for faster updates

2011-01-23 Thread Tom Hughes
On 23/01/11 17:59, Philipp Borgers wrote: Do we actually know that 9.0 is ok though? I was basing my comments on a single report of some preliminary tests at SOTM last year. Can someone explain the problem itself? We will set up our xapi database tomorrow and we would like to use 9.0. We can

[OSM-dev] Nominatim updates

2011-01-23 Thread Brian Quinion
Hi, On Monday morning I'm intending to switching the existing nominatim service over to an updated code base designed to allow better scaling and additional data sources (tiger, external postcode sets, etc) as well as being the first stage of various other improvements. With any luck the only

Re: [OSM-dev] [OSM-talk] Nominatim updates

2011-01-23 Thread Richard Weait
On Sun, Jan 23, 2011 at 7:55 PM, Brian Quinion openstreet...@brian.quinion.co.uk wrote: Hi, On Monday morning I'm intending to switching the existing nominatim service over to an updated code base designed to allow better scaling and additional data sources (tiger, external postcode sets,