Default include_dir behaviour

2021-09-22 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/config-setting.html
Description:

Dear postgres-team,

please consider adding a short line which clarifies what the default
behaviour of the `include_dir` paramter is if it is not set.
I am currently wondering if other .conf files in the default config
directory are included by default as well.

Thank you for your time.
Greetings,
Tobias


Re: Default include_dir behaviour

2021-09-22 Thread Tom Lane
PG Doc comments form  writes:
> please consider adding a short line which clarifies what the default
> behaviour of the `include_dir` paramter is if it is not set.

include_dir is not a parameter, it's a directive that's executed
while reading the file.

regards, tom lane




Re: Missing mention of autovacuum_work_mem

2021-09-22 Thread Euler Taveira
On Mon, Sep 20, 2021, at 10:40 AM, nikolai.berkoff wrote:
> Yes that reads better still.
I'm attaching a patch with Laurenz's words.


--
Euler Taveira
EDB   https://www.enterprisedb.com/
From 41f814b15349bcc8eb8ffa4624ed5af80f3476ac Mon Sep 17 00:00:00 2001
From: Euler Taveira 
Date: Wed, 22 Sep 2021 14:47:12 -0300
Subject: [PATCH v1] Improve vacumming indexes description

Mention autovacuum_work_mem if VACUUM is run by autovacuum.

Reported-by: Nikolai Berkoff
Author: Laurenz Albe
Reviewed-by: Nikolai Berkoff
Discussion: https://postgr.es/m/1kIqf6Q1G-wVkQkeg_BRSpcmy77hNfh9vlLQ3AF1APT-pKHRYT3z1IuDC5K2w83-4Qa016V1SfWJfF1v0Z0qf6141DbLcpIZJY3edlBEkCs%3D%40pm.me
---
 doc/src/sgml/monitoring.sgml | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
index 2281ba120f..451534602b 100644
--- a/doc/src/sgml/monitoring.sgml
+++ b/doc/src/sgml/monitoring.sgml
@@ -6147,8 +6147,9 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
VACUUM is currently vacuuming the indexes.  If a table has
any indexes, this will happen at least once per vacuum, after the heap
has been completely scanned.  It may happen multiple times per vacuum
-   if  is insufficient to
-   store the number of dead tuples found.
+   if  (or, in the case of autovacuum,
+   ) is insufficient to store the number
+   of dead tuples found.
  
 
 
-- 
2.20.1