PostgreSQL VACUUM

From wikieduonline
Revision as of 10:32, 11 July 2023 by Welcome (talk | contribs) (→‎News)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

PostgreSQL VACUUM garbage-collect and optionally analyze a database.

VACUUM reclaims storage occupied by dead tuples.


Examples

SELECT
  schemaname, relname,
  last_vacuum, last_autovacuum,
  vacuum_count, autovacuum_count
FROM pg_stat_user_tables;
select count(*) from pg_stat_activity where query like 'autovacuum:%';


PosgreSQL recommend that active production databases be vacuumed frequently (at least nightly), in order to remove dead rows. [1]

VACUUM causes a substantial increase in I/O traffic.

News

Logs

2023-07-10 10:01:39 UTC [520415]: LOG: skipping vacuum of "your_test" --- lock not available

Related terms

See also

  • https://www.postgresql.org/docs/current/sql-vacuum.html
  • Advertising: