Re: good experience with performance in 8.2 for multi column indexes

No, both negative.

Michael

Tom Lane wrote:
> Michael Enke <michael.enke@wincor-nixdorf.com> writes:
>
>>For my setup, in 8.1 a delete query which deletes 200000 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 much faster than the indexscan.
> I think the real issue is somewhere else.  Do you have any triggers
> or foreign keys on this table?
>
>             regards, tom lane

--
Wincor Nixdorf International GmbH
Sitz der Gesellschaft: Paderborn
Registergericht Paderborn HRB 3507
Gesch�ftsf�hrer: Eckard Heidloff (Vorsitzender), Stefan Auerbach, Dr. J�rgen Wunram
Vorsitzender des Aufsichtsrats: Karl-Heinz Stiller
Steuernummer: 339/5884/0020 - Ust-ID Nr.: DE812927716 - WEEE-Reg.-Nr. DE44477193

Diese E-Mail enth�lt vertrauliche Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt�mlich
erhaltenhaben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie
dieunbefugte Weitergabe dieser E-Mail ist nicht gestattet. 

This e-mail may contain confidential information. If you are not the intended recipient (or have received this e-mail
inerror) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or
distributionof the material in this e-mail is strictly forbidden.