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

From Tristen Raab
Subject Re: Correct the documentation for work_mem
Date
Msg-id 169083626116.1127.288822187162141328.pgcf@coridan.postgresql.org
Whole thread Raw
In response to Re: Correct the documentation for work_mem  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Correct the documentation for work_mem
List pgsql-hackers
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 patch. As it stands right now I think the documentation for
thissection is quite clear.
 

> I'm wondering about adding "and more than one of these operations may
> be in progress simultaneously".  Are you talking about concurrent
> sessions running other queries which are using work_mem too?

This appears to be referring to the "sort and hash" operations mentioned prior.

> If so,
> isn't that already covered by the final sentence in the quoted text
> above? if not, what is running simultaneously?

I believe the last sentence is referring to another session that is running its own sort and hash operations. So the
firstsection you mention is describing how sort and hash operations can be in execution at the same time for a query,
whilethe second refers to how sessions may overlap in their execution of sort and hash operations if I am understanding
thiscorrectly.
 

I also agree that changing "sort or hash" to "sort and hash" is a better description.

Tristen

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: CDC/ETL system on top of logical replication with pgoutput, custom client
Next
From: Jeff Davis
Date:
Subject: Re: pgsql: Fix search_path to a safe value during maintenance operations.