On Mon, Jan 10, 2011 at 11:09 PM, Frederik Ramm <[email protected]> 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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
