diff options
Diffstat (limited to 'docs/_queries/postgres.md')
| -rw-r--r-- | docs/_queries/postgres.md | 4 |
1 files changed, 4 insertions, 0 deletions
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 |