Re: Memory Accounting
Jeff Davis <pgsql@j-davis.com>
From: Jeff Davis <pgsql@j-davis.com>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Melanie Plageman <melanieplageman@gmail.com>, Soumyadeep Chakraborty
<sochakraborty@pivotal.io>, Robert Haas <robertmhaas@gmail.com>, Pg Hackers
<pgsql-hackers@postgresql.org>, soumyadeep2007@gmail.com
Date: 2019-09-30T20:34:13Z
Lists: pgsql-hackers
Attachments
- 0001-Memory-accounting-at-block-level.patch (text/x-patch) patch 0001
On Sun, 2019-09-29 at 00:22 +0200, Tomas Vondra wrote: > Notice that when CLOBBER_FREED_MEMORY is defined, the code first > > calls > > wipe_mem and then accesses fields of the (wiped) block. > > Interesringly > > enough, the regression tests don't seem to exercise these bits - > > I've > > tried adding elog(ERROR) and it still passes. For (2) that's not > > very > > surprising because Generation context is only really used in > > logical > > decoding (and we don't delete the context I think). Not sure about > > (1) > > but it might be because AllocSetReset does the right thing and only > > leaves behind the keeper block. > > > > I'm pretty sure a custom function calling the contexts explicitly > > would > > fall over, but I haven't tried. > > Fixed. I tested with some custom use of memory contexts. The reason AllocSetDelete() didn't fail before is that most memory contexts use the free lists (the list of free memory contexts, not the free list of chunks), so you need to specify a non-default minsize in order to prevent that and trigger the bug. AllocSetReset() worked, but it was reading the header of the keeper block after wiping the contents of the keeper block. It technically worked, because the header of the keeper block was not wiped, but it seems more clear to explicitly save the size of the keeper block. In AllocSetDelete(), saving the keeper size is required, because it wipes the block headers in addition to the contents. > Oh, and one more thing - this probably needs to add at least some > basic > explanation of the accounting to src/backend/mmgr/README. Added. Regards, Jeff Davis
Commits
-
Change MemoryContextMemAllocated to return Size
- 36425ece5d6c 13.0 landed
-
Use Size instead of int64 to track allocated memory
- f2369bc610a1 13.0 landed
-
Add transparent block-level memory accounting
- 5dd7fc151946 13.0 landed
-
Change the way pre-reading in external sort's merge phase works.
- e94568ecc10f 10.0 cited
-
Improve memory management for external sorts.
- 0011c0091e88 9.6.0 cited
-
In array_agg(), don't create a new context for every group.
- b419865a814a 9.5.0 cited