| From: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
|---|---|
| To: | John Naylor <johncnaylorls(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
| Subject: | Re: PostgreSQL 17 Beta 1 release announcement draft |
| Date: | 2024-05-20 11:47:54 |
| Message-ID: | f59461a1-7b54-4a68-812a-45e316c20f73@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 5/20/24 2:58 AM, John Naylor wrote:
> Hi Jon,
>
> Regarding vacuum "has shown up to a 6x improvement in overall time to
> complete its work" -- I believe I've seen reported numbers close to
> that only 1) when measuring the index phase in isolation or maybe 2)
> the entire vacuum of unlogged tables with one, perfectly-correlated
> index (testing has less variance with WAL out of the picture). I
> believe tables with many indexes would show a lot of improvement, but
> I'm not aware of testing that case specifically. Can you clarify where
> 6x came from?
Sawada-san showed me the original context, but I can't rapidly find it
in the thread. Sawada-san, can you please share the numbers behind this?
We can adjust the claim - but I'd like to ensure we highlight how the
changes to vacuum will visibly impact users.
Jonathan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2024-05-20 11:51:12 | Re: remaining sql/json patches |
| Previous Message | Jonathan S. Katz | 2024-05-20 11:44:11 | Re: PostgreSQL 17 Beta 1 release announcement draft |