Re: Use generation memory context for tuplestore.c

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Use generation memory context for tuplestore.c
Date: 2024-07-03 10:41:56
Message-ID: CAApHDvpwG5w1YeHLPD1M-nZ=k1omFUCAmLGNMSctHFR_f8-NYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thank you for having another look at this.

On Wed, 3 Jul 2024 at 00:20, Matthias van de Meent
<boekewurm+postgres(at)gmail(dot)com> wrote:
> I noticed this change to buffile.c shows up in both v1 and v2 of the
> patchset, but I can't trace the reasoning why it changed with this
> patch (rather than a separate bugfix):

I didn't explain that very well here, did I. I took up the discussion
about that in [1]. (Which you've now seen)

> > +show_material_info(MaterialState *mstate, ExplainState *es)
> > + spaceUsedKB = (tuplestore_space_used(tupstore) + 1023) / 1024;
>
> I think this should use the BYTES_TO_KILOBYTES macro for consistency.

Yes, that needs to be done. Thank you.

> Lastly, I think this would benefit from a test in
> regress/sql/explain.sql, as the test changes that were included
> removed the only occurrance of a Materialize node from the regression
> tests' EXPLAIN outputs.

I've modified the tests where the previous patch disabled
enable_material to enable it again and mask out the possibly unstable
part. Do you think that's an ok level of testing?

David

[1] https://postgr.es/m/CAApHDvofgZT0VzydhyGH5MMb-XZzNDqqAbzf1eBZV5HDm3%2BosQ%40mail.gmail.com

Attachment Content-Type Size
v3-0001-Remove-incorrect-Asserts-in-buffile.c.patch application/octet-stream 2.2 KB
v3-0002-Add-memory-disk-usage-for-Material-in-EXPLAIN-ANA.patch application/octet-stream 13.2 KB
v3-0003-Optimize-memory-management-and-increase-performan.patch application/octet-stream 4.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dean Rasheed 2024-07-03 10:41:58 Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands.
Previous Message shveta malik 2024-07-03 10:39:21 Re: Conflict Detection and Resolution