Re: Correct the documentation for work_mem

2023-09-26 Thread Bruce Momjian
On Wed, Sep 27, 2023 at 02:05:44AM +1300, David Rowley wrote: > On Tue, 12 Sept 2023 at 03:03, Bruce Momjian wrote: > > > > On Mon, Sep 11, 2023 at 10:02:55PM +1200, David Rowley wrote: > > > It's certainly not a show-stopper. I do believe the patch makes some > > > improvements. The reason I'd p

Re: Correct the documentation for work_mem

2023-09-26 Thread David Rowley
On Tue, 12 Sept 2023 at 03:03, Bruce Momjian wrote: > > On Mon, Sep 11, 2023 at 10:02:55PM +1200, David Rowley wrote: > > 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 th

Re: Correct the documentation for work_mem

2023-09-11 Thread Bruce Momjian
On Mon, Sep 11, 2023 at 10:02:55PM +1200, David Rowley wrote: > On Sat, 9 Sept 2023 at 14:25, Imseih (AWS), Sami 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 operation

Re: Correct the documentation for work_mem

2023-09-11 Thread David Rowley
On Sat, 9 Sept 2023 at 14:25, Imseih (AWS), Sami 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 follow

Re: Correct the documentation for work_mem

2023-09-08 Thread Imseih (AWS), Sami
> 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. This latest version of the patch looks good to me. Regards, Sami

Re: Correct the documentation for work_mem

2023-09-07 Thread David Rowley
On Fri, 8 Sept 2023 at 15:24, Bruce Momjian wrote: > Adjusted patch attached. 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. David

Re: Correct the documentation for work_mem

2023-09-07 Thread Bruce Momjian
On Fri, Apr 21, 2023 at 01:15:01PM -0400, Tom Lane wrote: > Peter Eisentraut writes: > > On 21.04.23 16:28, Imseih (AWS), Sami wrote: > >> I suggest a small doc fix: > >> “Note that for a complex query, several sort or hash operations might be > >> running simultaneously;” > > > Here is a discus

Re: Correct the documentation for work_mem

2023-08-01 Thread Imseih (AWS), Sami
Hi, Sorry for the delay in response and thanks for the feedback! > I've reviewed and built the documentation for the updated patch. As it stands > right now I think the documentation for this section is quite clear. Sorry, I am not understanding. What is clear? The current documentation -or- t

Re: Correct the documentation for work_mem

2023-07-31 Thread Tristen Raab
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: not tested Documentation:tested, passed Hello, I've reviewed and built the documentation for the updated

Re: Correct the documentation for work_mem

2023-07-12 Thread David Rowley
On Tue, 25 Apr 2023 at 04:20, Imseih (AWS), Sami wrote: > > Based on the feedback, here is a v1 of the suggested doc changes. > > I modified Gurjeets suggestion slightly to make it clear that a specific > query execution could have operations simultaneously using up to > work_mem. > -Note

Re: Correct the documentation for work_mem

2023-04-24 Thread Imseih (AWS), Sami
Based on the feedback, here is a v1 of the suggested doc changes. I modified Gurjeets suggestion slightly to make it clear that a specific query execution could have operations simultaneously using up to work_mem. I also added the small hash table memory limit clarification. Regards, Sami Ims

Re: Correct the documentation for work_mem

2023-04-21 Thread Imseih (AWS), Sami
> > especially since the next sentence uses "concurrently" to describe the > > other case. I think we need a more thorough rewording, perhaps like > > > > - Note that for a complex query, several sort or hash operations > > might be > > - running in parallel; each operation will gener

Re: Correct the documentation for work_mem

2023-04-21 Thread Gurjeet Singh
On Fri, Apr 21, 2023 at 10:15 AM Tom Lane wrote: > > Peter Eisentraut writes: > > On 21.04.23 16:28, Imseih (AWS), Sami wrote: > >> I suggest a small doc fix: > >> “Note that for a complex query, several sort or hash operations might be > >> running simultaneously;” > > > Here is a discussion of

Re: Correct the documentation for work_mem

2023-04-21 Thread Tom Lane
Peter Eisentraut writes: > On 21.04.23 16:28, Imseih (AWS), Sami wrote: >> I suggest a small doc fix: >> “Note that for a complex query, several sort or hash operations might be >> running simultaneously;” > Here is a discussion of these terms: > https://takuti.me/note/parallel-vs-concurrent/

Re: Correct the documentation for work_mem

2023-04-21 Thread Peter Eisentraut
On 21.04.23 16:28, Imseih (AWS), Sami wrote: I recently noticed the following in the work_mem [1] documentation: “Note that for a complex query, several sort or hash operations might be running in parallel;” The use of “parallel” here is misleading as this has nothing to do with parallel que