| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Victor Yegorov <vyegorov(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Deleting older versions in unique indexes to avoid page splits |
| Date: | 2020-11-17 04:59:34 |
| Message-ID: | CAH2-Wznnp4sTDasnCcaNa5nQiR34pNM0uee4DNK4-xtXuHBuCw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sun, Nov 15, 2020 at 2:29 PM Victor Yegorov <vyegorov(at)gmail(dot)com> wrote:
> TPS
> ---
> query | Master TPS | Patched TPS | diff
> ----------------+------------+-------------+-------
> UPDATE + SELECT | 2413 | 2473 | +2.5%
> 3 SELECT in txn | 19737 | 19545 | -0.9%
> 15min SELECT | 0.74 | 1.03 | +39%
>
> Based on the figures and also on the graphs attached, I can tell v8 has no visible regression
> in terms of TPS, IO pattern changes slightly, but the end result is worth it.
> In my view, this patch can be applied from a performance POV.
Great, thanks for testing!
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2020-11-17 05:58:35 | Re: pgbench: option delaying queries till connections establishment? |
| Previous Message | Tatsuro Yamada | 2020-11-17 04:35:07 | Re: list of extended statistics on psql |