3 ms·

Upcoming 9.6 has a great feature to speed up vacuum (thus keeping bloat controlled ).

• pritambaral 10y ago
  Was looking for a mention of this in the article.
• pilif 10y ago
  Not really. What's much faster is the wraparound protection vacuum which is a special more thorough vacuum that runs at a configured interval which defaults to every 200M transactions against a database. Only that one is sped up to now run roughly at the same speed as the normal vacuum
  • arthursilva 10y ago
    It looked to me that the freeze map allowed vacuum to skip pages not touched since last run, so avoiding a lot of work between runs.
    • anarazel 10y ago
      That's not new though - the visibility map has done so for years (8.4 IIRC).