On Mon, 2009-07-27 at 21:56 +0000, dan boeriu wrote:
> What I noticed is that the second will not finish if the READ table has many
> rows to be read (1 million let's say) but it finishes when the read table
> has only a few 1000s of rows.
> Any idea why?
It could be that it _does_ finish ... eventually. It might be doing
something that scales very poorly with number of input rows, like a
nested loop within a nested loop.
Can you provide EXPLAIN ANALYZE output for the problem query?
--
Craig Ringer