[OpenStreetMap] #4494: Relation members won't download

[Andy Allan]

On 27 July 2012 08:47, OpenStreetMap <trac at openstreetmap.org> wrote:

>  I've increased the stack depth limit as much as I can without restarting
>  the server and both of those relations now work - there will doubtless be
>  others which won't though.

Ah, stack depth limits. This is a problem I was running into trying to
run the API on my laptop, and I presume lots of other people will too.

When you look at the queries they aren't doing much that's
complicated, and would be much simpler as e.g. node_id in (123, 234,
345) rather than ((node_id = 123) or (node_id = 234) or ...)

Tom, would you say this is a bug in rails (arel making stupid queries)
or in postgres itself, using a huge chunk of memory for a (reasonably)
straightforward query?

Cheers,
Andy