| From: | "Saul, Jean Paolo" <paolo(dot)saul(at)verizonconnect(dot)com> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes |
| Date: | 2019-01-31 03:08:39 |
| Message-ID: | CA+73ANe-m3+UFpvQTif4BxMmAuJ0Vnz-i3wBgTMXJwMWDx47Mw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Additional tests replacing BTREE indexes with HASH indexes indicate that
hash indexes do not suffer from low-cardinality performance regression.
However I cannot use hash indexes in our systems as they are discouraged.
>
--------------------------------------------------------------------------------------------------------------------------------------------
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL
VERIZON CONNECT CONFIDENTIALITY NOTICE
This message is intended for the addressee only and may contain confidential and/or privileged material. Any review, re-transmission, dissemination, reliance upon or other use of this information by persons or entities other than the addressee is prohibited. If you receive this in error, please contact the sender and delete this message. Thank you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2019-01-31 09:33:57 | BUG #15614: Query plan: buffer stats from workers in child operations discarded. |
| Previous Message | Saul, Jean Paolo | 2019-01-31 02:06:01 | Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes |