Re: PostgreSQL 17 Beta 1 release announcement draft

From: John Naylor <johncnaylorls(at)gmail(dot)com>
To: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL 17 Beta 1 release announcement draft
Date: 2024-05-20 06:58:48
Message-ID: CANWCAZZZTtgN7_iW849U_o-vxoFy6WsEc=Kgf1CheaKJULHSmQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2024-05-20 07:11:22 Re: Schema variables - new implementation for Postgres 15
Previous Message Shlok Kyal 2024-05-20 06:46:17 Re: Pgoutput not capturing the generated columns