Thanks for the response :)
You could probably get your larger server to try the no-sort plan if
you said "set enable_sort = 0" first. It would be interesting to
compare the EXPLAIN ANALYZE results for that case with the other
server.
Odd, I went to investigate this switch on the larger server,
Thanks for the response :)
That's 50-ish ms versus 80-odd seconds.
It seems to me a merge join might be more appropriate here than a
nestloop. What's your work_mem set at? Off-the-cuff numbers show the
dataset weighing in the sub-ten mbyte range.
Provided it's not already at least that big, and yo
