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-02-10 23:05:09 |
Message-ID: | CA+73ANffu7xZDPOAtH5=jNsN2eyOWx8Dw0R4Hi_92pxqm4=1Ag@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi All,
I have found a short term workaround for this. You recreate the index with
an added second column with high-cardinality.
ex. CREATE INDEX ON test_indexes USING BTREE (low_cardinality_column,
primary_key_id);
We have around 1,500 tables with low-cardinality indexes, so its not the
best workaround but one that restores the performance bump for PG11.
Can anyone please shed some light as to why this works?
The only thing I could think of is a locking issue with the leaf nodes.
How much testing is required for this to be considered a proper bug?
Cheers,
Paolo
--------------------------------------------------------------------------------------------------------------------------------------------
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-02-10 23:44:46 | BUG #15628: Error while installing postgreSQL |
Previous Message | Tom Lane | 2019-02-10 22:39:19 | Re: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name |