menu
techminis

A naukri.com initiative

google-web-stories
Home

>

Databases

>

PostgreSQL...
source image

Dbi-Services

1w

read

213

img
dot

PostgreSQL 18: Add “–missing-stats-only” to vacuumdb

  • PostgreSQL 18 introduces a new switch for vacuumdb, '--missing-stats-only'.
  • This switch allows vacuumdb to only collect statistics on objects that do not have any.
  • Previously, losing all object statistics after a major version upgrade was a pain point in PostgreSQL.
  • With this new switch, it becomes easier to collect fresh statistics without analyzing all objects.

Read Full Article

like

12 Likes

For uninterrupted reading, download the app