| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Deleting older versions in unique indexes to avoid page splits |
| Date: | 2020-10-24 09:55:13 |
| Message-ID: | CANP8+jLt6Gf38z-p_FETdSwaCJgK4MskxM_VuRtNM9ZEsqMbeQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 23 Oct 2020 at 18:14, Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> It's obvious that a page split is more expensive than the delete
> operation (when it works out).
The problem I highlighted is that the average UPDATE latency is x2
what it is on current HEAD. That is not consistent with the reported
TPS, so it remains an issue and that isn't obvious.
> It doesn't need a microbenchmark (and I
> really can't think of one that would make any sense).
I'm asking for detailed timings so we can understand the latency
issue. I didn't ask for a microbenchmark.
I celebrate your results, but we do need to understand the issue, somehow.
--
Simon Riggs http://www.EnterpriseDB.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2020-10-24 13:02:59 | Re: [doc] remove reference to pg_dump pre-8.1 switch behaviour |
| Previous Message | Michael Paquier | 2020-10-24 05:25:36 | Re: speed up unicode decomposition and recomposition |