On Thu, Mar 19, 2020 at 3:27 PM Jeff Davis <pg...@j-davis.com> wrote: > I think omitting the tail of the current block is an unqualified > improvement for the purpose of obeying work_mem, regardless of the OS. > The block sizes keep doubling up to 8MB, and it doesn't make a lot of > sense to count that last large mostly-empty block against work_mem.
Well, again, my point is that whether or not it counts depends on your system's overcommit behavior. Depending on how you have the configured, or what your OS likes to do, it may in reality count or not count. Or so I believe. Am I wrong? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
