Hi there,I've been stuck with this for a while and I'm not sure if I'm running into a bug or I'm just doing something very wrong.
I have this stripped-down version of my query: https://gist.github.com/spacepluk/9ab1e1a0cfec6f0efb298f023f4c805b
The data is just a single file with one record (1.5K).Without changing anything, explain takes ~1sec on my machine. But if I uncomment the where clause then it runs for a couple of hours until it runs out of memory.
Also if I uncomment the where clause *and* take out the join, then it takes around 30s to plan.
Any ideas? Thanks!
signature.asc
Description: Digital signature
