Subject: Re: Additional Chapter for Tutorial
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,
 pgsql-docs@lists.postgresql.org
References: <13c65997-9502-7671-1a7b-50e5d5093514@purtz.de>
 <40aca6b45b0da614b94c8ef86d89b70b@xs4all.nl>
 <4b8bdb3b-10a7-e541-18ff-6a556ce89cd1@purtz.de>
 <9df5b9c8-71fe-47a8-4670-346a0ae7e2cd@purtz.de>
 <d2a0cb79-7c87-9bb2-2bb9-9465ba69d854@2ndquadrant.com>
 <f3eeae6c-7e4d-4185-d792-9c97b9fd65f1@purtz.de>
 <567f7c92-dce9-7424-9022-54b31eb12740@purtz.de>
 <1B5F7D1E-B389-4D3B-973A-A8D183D8530A@yesql.se>
 <fdd0fd52-84d3-f7a1-b8c7-aed108d95615@purtz.de>
 <766cab17c6af48956558611520956b77@xs4all.nl>
 <ddfd3e05-407c-5e7b-d9f1-fadee15b5348@purtz.de>
 <d8e2f31f-f2e8-0482-2b10-2ae06a6b8fb7@2ndquadrant.com>
 <93fd8e15-8639-23c8-c7c4-d4cfca323189@purtz.de>
 <c02449fa-5873-bddf-348e-cf174faa77e0@2ndquadrant.com>
From: =?UTF-8?Q?J=c3=bcrgen_Purtz?= <juergen@purtz.de>
Message-ID: <ef235a2b-2297-f28b-708a-5ce9b95ac00c@purtz.de>
Date: Fri, 11 Sep 2020 09:49:23 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
In-Reply-To: <c02449fa-5873-bddf-348e-cf174faa77e0@2ndquadrant.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

On 10.09.20 18:26, Peter Eisentraut wrote:
> On 2020-09-02 09:04, Jürgen Purtz wrote:
>> On 01.09.20 23:30, Peter Eisentraut wrote:
>>> It is mostly advanced low-level information that is irrelevant for
>>> someone starting up,
>> That applies only to the VACUUM chapter. VACUUM and AUTOVACUUM are
>> controlled by a lot of parameters. Therefor the current documentation
>> concerning the two mechanism spreads the description across different
>> pages (20.4, 25.1, VACUUM command). Because of the structure of our
>> documentation that's ok. But we should have a summary page somewhere -
>> not necessarily in the tutorial.
>
> There is probably room for improvement, but the section numbers you 
> mention are not about VACUUM, AFAICT, so I can't really comment on 
> what you have in mind.
>
Because of the additional chapter for the 'tutorial' on my local 
computer, the numbers increased for me. The regular chapter numbers are 
19.4 and 24.1. Sorry for the confusion. In detail:

19.4: parameters to configure the server, especially five parameters 
'vacuum_cost_xxx'.

19.10: parameters to configure autovacuum.

19.11: parameters to configure client connections, especially five 
parameters 'vacuum_xxx' concerning their freeze-behavior.

24.1: explains the general necessity of (auto)vacuum and their strategies.

The page about the SQL command VACUUM explains the different options 
(FULL, FREEZE, ..) and their meaning.

--

Jürgen Purtz