diff options
| author |  Chris Lovering <[email protected]> | 2023-08-14 15:33:24 +0100 |
|---|---|---|
| committer | Chris Lovering <[email protected]> | 2023-08-14 15:33:24 +0100 |
| commit | 41875f7f94a4bbe60becfe943d101361d3ad4b81 (patch) | |
| tree | a777be5955fab432f68f18866081e0feffa6f63d | |
| parent | Move k8s jekyll config to docs/ (diff) | |
Update query docs with recommendations
Co-authored-by: jchristgit <[email protected]>
| -rw-r--r-- | docs/_queries/kubernetes.md | 2 | ||||
| -rw-r--r-- | docs/_queries/postgres.md | 4 |
2 files changed, 5 insertions, 1 deletions
diff --git a/docs/_queries/kubernetes.md b/docs/_queries/kubernetes.md index 032ad70..e7600d3 100644 --- a/docs/_queries/kubernetes.md +++ b/docs/_queries/kubernetes.md @@ -25,4 +25,4 @@ $ kubectl top nodes --sort-by='memory' ## Lens IDE -[Open Lens IDE](https://k8slens.dev){: .btn .btn-purple }{:target="_blank"} +[OpenLens](https://github.com/MuhammedKalkan/OpenLens){: .btn .btn-purple }{:target="_blank"} 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 |