Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tWOTK-00GI4B-BI for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Jan 2025 23:31:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tWOTI-003zbu-M9 for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Jan 2025 23:31:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tWOTI-003zbm-7O for pgsql-hackers@lists.postgresql.org; Fri, 10 Jan 2025 23:31:19 +0000 Received: from mail-ed1-x536.google.com ([2a00:1450:4864:20::536]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tWOTF-000xDh-2I for pgsql-hackers@postgresql.org; Fri, 10 Jan 2025 23:31:18 +0000 Received: by mail-ed1-x536.google.com with SMTP id 4fb4d7f45d1cf-5d4e2aa7ea9so4939631a12.2 for ; Fri, 10 Jan 2025 15:31:17 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736551876; x=1737156676; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=s3+RqPIdFO93sVhdV2XWb7gj/7oIy9GrYRqr1YZ3838=; b=X+4u4zjKuKL7Av4arZDKgsVz1Igq4iHPHDVd7/YryCrMY8ftjHUBNVxJA+pij0RYKw cUX866piHYdP7xOQKqh6DO9EYwXYwrXDD2YYlP9lcZxpkwRafowCUP2sFZyLBTLGMGQy nSxiLb5L5thgxOkDgr6WDyLF2kIjOEvnw/8/7FvB4SWBc15uU3xZmcTE+3Rwysl+Wn+J buUyO2Lt9KKoQwH92zUbTG8bCacpQkPupdGcX1e7cXJ0mGc9qtr+G3dytlRYe08FQSYI 78tggWTL4hzJR/+z+jegKBH7fditSBdP/KZ2afGOssoIYkUNg7cFUotzp5v8BwRn8Sqx YQIA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736551876; x=1737156676; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=s3+RqPIdFO93sVhdV2XWb7gj/7oIy9GrYRqr1YZ3838=; b=IaF6WpPqLAC1jp4kwVlh/FOSVtYBSuVxeJd8DQ7E+vlK+UQOW7I91c5dkOENHfuKk6 aAFSKHtz4WXYa9T+qpPYEJku9T1pgRGbp66dg9yoWM/If1e0HxRN/1yTWNfusaUx+CrZ cNiVDPBcx3tynAro5k+LWsxpGkcsbq9TAvKy1dnALJFN6xURmkXOf3zufdqvnF7ACuoj q4ajqaEHJVy7SDIubefgMnvg9VKSf0YuyK1IIZwGHpag/H1GYIjIpiXWicwtCcVw3g2M MD+BSq2JpszCnySalHISZJ8nfkItm0FBMwaMKnxW4VHYdy9LkzBGzWgYT3Leu8oSzC2h GlQg== X-Forwarded-Encrypted: i=1; AJvYcCXeo0IxyNHWmvv/SGhXrw8Tx2HVGOX7Fl7LgFYRODpnP3t+2Lz/EFglXAiSy8h2hxWEg0EV9lvUqkG1hcX0@postgresql.org X-Gm-Message-State: AOJu0YxtN3dlF8DXsu8TYej42UbTCS0Zwx+NppV/4IyaRlqcjmhN5AFH gYhUlCYW3AYmtfWbj07EdDwTU1Pk/MnXvJujlIx9QdHVK49PUxXOePrQlmue5mI3oF7ftO67hCw yByJ87egEz1qzf3s/sZYlxIXINeM= X-Gm-Gg: ASbGncuGcd4ay0Zy5Lofvdym5tSm0xL696/q2OzWghfWxxY+SfNoecjIrmTy6myea7l fsghvwkE3F+b4zep4Y2UZd2e/VnumStKPjmJJdY+7CaD0b4IVW8vBpxxd05Et7wGiHj6wMrwF X-Google-Smtp-Source: AGHT+IGnCZpsrPLI/0LLJJbfJjT1ejbd89Vp61TNOvsJS9j5kAC+M5fH3wL4vUwFuKvQ1wrsUSEUh/KSfJJRLTzaEJM= X-Received: by 2002:a05:6402:5244:b0:5d0:8197:7ab3 with SMTP id 4fb4d7f45d1cf-5d972dfb878mr11783926a12.3.1736551876114; Fri, 10 Jan 2025 15:31:16 -0800 (PST) MIME-Version: 1.0 References: <1373018.1736213217@sss.pgh.pa.us> <68a4435c-3990-419d-a68a-b33a7f9185ab@eisentraut.org> <77916C10-F124-4652-B842-92508E1696B6@yesql.se> In-Reply-To: <77916C10-F124-4652-B842-92508E1696B6@yesql.se> From: Melanie Plageman Date: Fri, 10 Jan 2025 18:31:04 -0500 X-Gm-Features: AbW1kva73owCTiFapblBRqMi3jSuxXNxkhCimSv6flDNidBc8WWiJH5jFMQfZcM Message-ID: Subject: Re: Moving the vacuum GUCs' docs out of the Client Connection Defaults section To: Daniel Gustafsson Cc: Peter Eisentraut , Tom Lane , PostgreSQL Hackers , "Bossart, Nathan" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jan 10, 2025 at 6:00=E2=80=AFPM Daniel Gustafsson = wrote: > > > On 10 Jan 2025, at 23:09, Melanie Plageman = wrote: > > > > On Thu, Jan 9, 2025 at 5:05=E2=80=AFPM Daniel Gustafsson wrote: > >> > >> I think this is a really good restructuring which will make life easie= r for our > >> users. Some of the comments below are on wording which wasn't introdu= ced in > >> this patch, but which I hadn't thought about before, so feel free to i= gnore > >> those comments. > >> > >> + > >> + Freezing > >> + > >> + > >> Trying to read this as a new user, I think it would be good to start t= his > >> subsection with a sentence describing what freezing actually is. Vacu= um is > >> hard enough for users as it is =3D) > > > > I've taken a stab at improving this. Let me know if you think it works. > > I like what you added, it's IMO the right level of detail here. Cool, thanks! I pushed. > + Specifies the cutoff age (in multixacts) that VACUUM > I wish we had a glossary entry for multixact we could link to here. But, > that's not really the responsibility of this patch to fix, just something= that > came to mind when reading the resulting page. Personally, I really wish we had a docs page explaining more about what mutlixacts are and maybe even a bit about the architecture. FWIW, the index [1] has an entry for MultiXacts but it goes straight to MultiXacts and Wraparound [2]. - Melanie [1] https://www.postgresql.org/docs/devel/bookindex.html [2] https://www.postgresql.org/docs/devel/routine-vacuuming.html#VACUUM-FOR= -MULTIXACT-WRAPAROUND