Re: Problem with a rule on upgrade to v7.1.1

Jon Lapham <lapham(at)extracta(dot)com(dot)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