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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
