pgPedia

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Top / V

• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Useful articles

System catalog tables
System catalog views
System statistics views
Progress reporting views

Contrib modules
Storage parameters (relopts)

xlog renaming in Pg 10

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

explain.depesz.com/

vacuumdb

vacuumdb is a core utility for vacuuming and analyzing PostgreSQL.

vacuumdb was added in PostgreSQL 7.0.

Source code

The vacuumdb source code is located at src/bin/scripts/vacuumdb.c.

Change history

• PostgreSQL 14
  • option --no-index-cleanup added (commit 9550ea30)
  • option --no-truncate added (commit 9550ea30)
• PostgreSQL 13
  • option --parallel added (commit 47bc9ced)
• PostgreSQL 12
  • options --min-xid-age and --min-mxid-age added (commit 00d1e88d)
  • options --disable-page-skipping and --skip-locked added (commit 354e95d1)
• PostgreSQL 9.5
  • option -j/--jobs for parallel processing added (commit a1792320)
• PostgreSQL 9.4
  • option --analyze-in-stages added (commit c92c3d50)
• PostgreSQL 9.3
  • multiple -t/--table arguments supported (commit f3af5344)
• PostgreSQL 9.0
  • option --analyze-only added (commit 3ccb97b2)
• PostgreSQL 8.4
  • option --freeze added (commit 36a9cf38)
  • option -w/--no-password added (commit 9de59fd1)
• PostgreSQL 8.3
  • Ctrl-C interrupt handler added (commit 6e09df9d)
• PostgreSQL 7.4
  • converted from a shell script into a C program (commit f374a9da)
• PostgreSQL 7.0
  • added (commit 240e4c98)

References

Categories

See also