Re: [HACKERS] [PATCH] Vacuum: Update FSM more frequently

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: Claudio Freire <klaussfreire@gmail.com>

Cc: Masahiko Sawada <sawada.mshk@gmail.com>, PostgreSQL-Dev <pgsql-hackers@postgresql.org>

Date: 2018-02-07T17:02:38Z

Lists: pgsql-hackers

On Tue, Feb 6, 2018 at 7:51 AM, Claudio Freire <klaussfreire@gmail.com> wrote:
> No free space becomes visible during long-running vacuums. That means
> bloat keeps accumulating even though vacuum is freeing space, because
> the FSM doesn't expose that free space.
>
> The extra work incurred in those FSM vacuums isn't useless, it's
> preventing bloat in long-running vacuums.

+1.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

Do index FSM vacuuming sooner.
- c79f6df75dd3 11.0 landed
Remove UpdateFreeSpaceMap(), use FreeSpaceMapVacuumRange() instead.
- a063baaced27 11.0 landed
While vacuuming a large table, update upper-level FSM data every so often.
- 851a26e26637 11.0 landed
Simplify autovacuum work-item implementation
- 31ae1638ce35 11.0 cited