[OSM-dev] scaling

Matt Amos zerebubuth at gmail.com
Tue Jan 11 00:22:35 GMT 2011


On Mon, Jan 10, 2011 at 11:09 PM, Frederik Ramm <frederik at remote.org> wrote:
> Brett Henderson wrote:
>>
>> That's not ideal. What's the implication of this? What OSM code uses
>> temp tables?
>>
>> Osmosis uses them for extraction of minutely diffs. Are there others?
>
> Matt's cgimap code does.

it's possible to rewrite it so that it doesn't use temp tables, but
that would be at the cost of more complex queries or higher memory
usage. i presume that postgres doesn't currently allow it because it's
technically non-trivial, but beyond that i have no idea what the level
of difficulty is...

i had a quick look on the postgres mailing lists and didn't spot
anything obvious about it - is it worth bringing it up there and
seeing what their take on it is?

cheers,

matt



More information about the dev mailing list