From: | Michael Enke <michael(dot)enke(at)wincor-nixdorf(dot)com> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org, psql-performance(at)postgresql(dot)org |
Subject: | Re: good experience with performance in 8.2 for multi column indexes |
Date: | 2008-04-18 14:49:54 |
Message-ID: | 4808B512.1060303@wincor-nixdorf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
No, both negative.
Michael
Tom Lane wrote:
> Michael Enke <michael(dot)enke(at)wincor-nixdorf(dot)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
Geschftsfhrer: Eckard Heidloff (Vorsitzender), Stefan Auerbach, Dr. Jrgen Wunram
Vorsitzender des Aufsichtsrats: Karl-Heinz Stiller
Steuernummer: 339/5884/0020 - Ust-ID Nr.: DE812927716 - WEEE-Reg.-Nr. DE44477193
Diese E-Mail enthlt vertrauliche Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtmlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte 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 in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
From | Date | Subject | |
---|---|---|---|
Next Message | Keaton Adams | 2008-04-18 15:30:18 | How to tell if 64 bit vs 32 bit engine? |
Previous Message | Dave | 2008-04-18 14:48:07 | Re: How do I measure user disk usage on Postgresql table? |