Jon Lapham <lapham@extracta.com.br> writes:
> I didn't do Pgv7.0.3 b/c I think it may be unnecessary
> since 7.1RC1 doesn't show this problem, while 7.1.1 does. But, if you
> really think it necessary, I will repeat his using 7.0.3.
No, that seems like useless work.
> 1) As usual, the 7.1RC1 returns from the "UPDATE ... " command as fast
> as I press enter. The 7.1.1 returns from the "UPDATE ... " command in
> about 10 minutes.
> 2) The two explains are identical.
Oh, *that's* interesting.
> 5) There are 8664 and 3680 tuples in the "tplantorgan" and "tplant" tables
> respectively. So this is a relatively small DB.
Would you be willing to send me a dump of the whole DB (or at least the
tables needed for this query)?
regards, tom lane
