Difference between revisions of "PostgreSQL VACUUM"

From wikieduonline
Jump to navigation Jump to search
Line 21: Line 21:
  
 
VACUUM causes a substantial increase in [[I/O]] traffic.
 
VACUUM causes a substantial increase in [[I/O]] traffic.
 +
 +
== News ==
 +
* [[PostgreSQL 13]] parallelized vacuuming of indexes
 +
 +
  
 
== Related terms ==
 
== Related terms ==

Revision as of 10:58, 14 April 2022

PostgreSQL VACUUM garbage-collect and optionally analyze a database.

VACUUM reclaims storage occupied by dead tuples.


Examples:

  • VACUUM (VERBOSE, ANALYZE) my_table;
  • VACUUM FULL my_table;
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


Related terms

See also

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