Re: Correct the documentation for work_mem - Mailing list pgsql-hackers

From David Rowley
Subject Re: Correct the documentation for work_mem
Date
Msg-id CAApHDvp2sAr9QLwucFLqz+uaO5iMxsy0uUEdoGTqw5r7iZ4Yzw@mail.gmail.com
Whole thread Raw
In response to Re: Correct the documentation for work_mem  ("Imseih (AWS), Sami" <simseih@amazon.com>)
Responses Re: Correct the documentation for work_mem
List pgsql-hackers
On Sat, 9 Sept 2023 at 14:25, Imseih (AWS), Sami <simseih@amazon.com> wrote:
>
> > This looks mostly fine to me modulo "sort or hash". I do see many
> > instances of "and/or" in the docs. Maybe that would work better.
>
> "sort or hash operations at the same time" is clear explanation IMO.

Just for anyone else following along that haven't seen the patch. The
full text in question is:

+        Note that a complex query might perform several sort or hash
+        operations at the same time, with each operation generally being

It's certainly not a show-stopper. I do believe the patch makes some
improvements.  The reason I'd prefer to see either "and" or "and/or"
in place of "or" is because the text is trying to imply that many of
these operations can run at the same time. I'm struggling to
understand why, given that there could be many sorts and many hashes
going on at once that we'd claim it could only be one *or* the other.
If we have 12 sorts and 4 hashes then that's not "several sort or hash
operations", it's "several sort and hash operations".  Of course, it
could just be sorts or just hashes, so "and/or" works fine for that.

David



pgsql-hackers by date:

Previous
From: Rajendra Kumar Dangwal
Date:
Subject: Re: Pgoutput not capturing the generated columns
Next
From: vignesh C
Date:
Subject: Re: pg_upgrade and logical replication