From: | Melanie Plageman <melanieplageman(at)gmail(dot)com> |
---|---|
To: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
Cc: | Peter Eisentraut <peter(at)eisentraut(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, "Bossart, Nathan" <bossartn(at)amazon(dot)com> |
Subject: | Re: Moving the vacuum GUCs' docs out of the Client Connection Defaults section |
Date: | 2025-01-10 22:09:22 |
Message-ID: | CAAKRu_a52vCax5+AN7MstfMckuR1qxyfTmssyPhqZv+9mNiMGQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Jan 9, 2025 at 5:05 PM Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:
>
> I think this is a really good restructuring which will make life easier for our
> users. Some of the comments below are on wording which wasn't introduced in
> this patch, but which I hadn't thought about before, so feel free to ignore
> those comments.
>
> + <sect2 id="runtime-config-vacuum-freezing">
> + <title>Freezing</title>
> +
> + <para>
> Trying to read this as a new user, I think it would be good to start this
> subsection with a sentence describing what freezing actually is. Vacuum is
> hard enough for users as it is =)
I've taken a stab at improving this. Let me know if you think it works.
> + default value is one.
> Grepping around indicates that we typically use the numeric value rather than
> writing it in text, and the next settting down has "default value is 2". For
> consistency I would change that to "1" instead of "one".
I think this is a reasonable cleanup to lump in with the rest of this
commit. I have taken the liberty of also adding a <literal> tag and
then updating the other places in the proposed "Vacuuming" subsection
where a literal default value is specified without the <literal> tag.
> + <varname>vacuum_cost_delay</varname>. Then it will reset the counter and
> + continue execution.
> I know starting a sentence with "Then" is grammatically correct when it's the
> last sentence in a paragraph, but being a non-native speaker I always find
> myself re-reading such sentences to parse them as they stand out as odd.
I hear you. I couldn't think of something much clearer, so I left it as is.
> + can be set to fractional-millisecond values, such delays may not be
> + measured accurately on older platforms. On such platforms,
> This sentence seems quite vague and hard to act on for users, what qualifies as
> an "older platform" by the time v18 rolls around (this was added in v12). I'm
> sure there are such platforms in existence that postgres 18 will run on, but
> are we helping users with ambiguity?
While I agree that what counted as older hardware in 2019 may no
longer be around at all, I am more hesitant to update this in the same
commit as a bunch of other cut-and-pastes. Someone at some point
decided this was important to point out, and I don't have sufficient
evidence that it no longer makes sense. And if I did, I'd probably
want to update this part of the docs in a dedicated commit.
- Melanie
Attachment | Content-Type | Size |
---|---|---|
v3-0001-Consolidate-docs-for-vacuum-related-GUCs-in-new-s.patch | application/octet-stream | 61.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Sami Imseih | 2025-01-10 22:26:05 | Re: POC: track vacuum/analyze cumulative time per relation |
Previous Message | Tom Lane | 2025-01-10 21:37:56 | Re: Memory leak in plpython3u (with testcase and patch) |