Re: Limiting memory allocation - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Limiting memory allocation
Date
Msg-id Yo2H14iyZ7YmJHra@momjian.us
Whole thread Raw
In response to Re: Limiting memory allocation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Limiting memory allocation
List pgsql-hackers
On Tue, May 24, 2022 at 09:20:43PM -0400, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > On Tue, May 24, 2022 at 07:40:45PM -0400, Tom Lane wrote:
> >> (1) There are not a predetermined number of allocations.  For example,
> >> if we do a given join as nestloop+inner index scan, that doesn't require
> >> any large amount of memory; but if we do it as merge or hash join then
> >> it will consume memory.
> 
> > Uh, we know from the plan whether we are doing a nestloop+inner or merge
> > or hash join, right?  I was suggesting we look at the plan before
> > execution and set the proper percentage of work_mem for each node.
> 
> Then you just rendered all the planner's estimates fantasies.

That's what I was asking --- if the planner's estimates are based on the
size of work_mem --- I thought you said it is not.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: allow building trusted languages without the untrusted versions
Next
From: Michael Paquier
Date:
Subject: Re: Improve TAP tests of pg_upgrade for cross-version tests