[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