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?
- Re: PostgreSQL 17 Beta 1 release announcement dr... Thom Brown
- Re: PostgreSQL 17 Beta 1 release announcemen... David Rowley
- Re: PostgreSQL 17 Beta 1 release announcement dr... Jonathan S. Katz
- Re: PostgreSQL 17 Beta 1 release announcement draft Alvaro Herrera
- Re: PostgreSQL 17 Beta 1 release announcement dr... Jonathan S. Katz
- Re: PostgreSQL 17 Beta 1 release announcement draft jian he
- Re: PostgreSQL 17 Beta 1 release announcement dr... Jonathan S. Katz
- Re: PostgreSQL 17 Beta 1 release announcement draft Jonathan S. Katz
- Re: PostgreSQL 17 Beta 1 release announcement dr... Alvaro Herrera
- Re: PostgreSQL 17 Beta 1 release announcemen... Jonathan S. Katz
- Re: PostgreSQL 17 Beta 1 release announcement draft John Naylor
- Re: PostgreSQL 17 Beta 1 release announcement draft Jonathan S. Katz
- Re: PostgreSQL 17 Beta 1 release announcement dr... Masahiko Sawada
- Re: PostgreSQL 17 Beta 1 release announcemen... John Naylor
- Re: PostgreSQL 17 Beta 1 release announc... Jonathan S. Katz