No, both negative.
Michael
Tom Lane wrote:
Michael Enke <[EMAIL PROTECTED]> writes:
For my setup, in 8.1 a delete query which deletes 20 entries depending on
rows in another table
runs about 7h, in 8.2 (and later) it runs 9s!
If those rowcount estimates are even close to accurate, the
Michael Enke <[EMAIL PROTECTED]> writes:
> For my setup, in 8.1 a delete query which deletes 20 entries depending on
> rows in another table
> runs about 7h, in 8.2 (and later) it runs 9s!
If those rowcount estimates are even close to accurate, there's no
reason for the hash plan to be so muc
Hi,
your query cant perform well on 8.1
better use a query like
delete from pluext1 using pluext2 where pluext1.plunmbr =
pluext2.plunmbr and pluext1.pluexttype = pluext2.pluexttype
it should perform much faster. be sure to use indizes
regards
thomas
Michael Enke schrieb:
Hi lists,
I want
