From 41875f7f94a4bbe60becfe943d101361d3ad4b81 Mon Sep 17 00:00:00 2001 From: Chris Lovering Date: Mon, 14 Aug 2023 15:33:24 +0100 Subject: Update query docs with recommendations Co-authored-by: jchristgit --- docs/_queries/postgres.md | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'docs/_queries/postgres.md') diff --git a/docs/_queries/postgres.md b/docs/_queries/postgres.md index 13728f6..e3deb82 100644 --- a/docs/_queries/postgres.md +++ b/docs/_queries/postgres.md @@ -232,6 +232,8 @@ CLUSTER [VERBOSE] When a table is clustered, it is physically reordered based on the index information. +The [clusterdb](https://www.postgresql.org/docs/current/app-clusterdb.html) CLI tool is recommended, and can also be used to cluster all tables at the same time. + ### VACUUM-ing Proper vacuuming, particularly autovacuum configuration, is crucial to a fast and reliable database. @@ -240,6 +242,8 @@ Proper vacuuming, particularly autovacuum configuration, is crucial to a fast an It is not advised to run `VACUUM FULL`, instead look at clustering. VACUUM FULL is a much more intensive task and acquires an ACCESS EXCLUSIVE lock on the table, blocking reads and writes. Whilst `CLUSTER` also does acquire this lock it's a less intensive and faster process. +The [vacuumdb](https://www.postgresql.org/docs/current/app-vacuumdb.html) CLI tool is recommended for manual runs. + #### Finding number of dead rows ```sql -- cgit v1.2.3