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?
In response to
pgsql-bugs by date
|Next:||From: Craig Ringer||Date: 2009-07-28 06:13:55|
|Subject: Re: BUG #4945: Parallel update(s) gone wild|
|Previous:||From: Fabiano||Date: 2009-07-28 00:06:12|
|Subject: BUG #4946: bug - libiconv-2.dll|