[OSM-dev] Patch to osm2pgsql for faster updates

[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 performance problem that we saw using an
>> 8.4 database. The general consensus was that it was somehow related to
>> the GIN indexes but we never managed to work out exactly what it was.
>
> Erik mentions encountering the same issue in 9.0. So either
> fastupdate=on is more intelligent in 9.0, or we're not on the right
> track to solve our 8.4 slowdown troubles.

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.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://compton.nu/