From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
---|---|
To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Noah Misch <noah(at)leadboat(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Don't overwrite scan key in systable_beginscan() |
Date: | 2024-12-03 08:15:18 |
Message-ID: | 22bffe21-5fa1-4be4-a757-a49a70908356@eisentraut.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 27.11.24 16:35, Justin Pryzby wrote:
> On Wed, Nov 27, 2024 at 04:33:25PM +0100, Peter Eisentraut wrote:
>> On 26.11.24 14:56, Justin Pryzby wrote:
>>> Since 811af9786b, the palloc'd idxkey's seem to be leaking/accumulating
>>> throughout the command.
>>>
>>> I noticed this on the master branch while running ANALYZE on partitioned
>>> table with 600 attributes, even though only 6 were being analyzed.
>>>
>>> LOG: level: 3; BuildRelationExtStatistics: 1239963512 total in 278 blocks; 5082984 free (296 chunks); 1234880528 used
>>>
>>> Several indexes are being scanned many thousands of times.
>>
>> Hmm, this patch inserts one additional palloc() call per
>> systable_beginscan(). So it won't have much of an impact for isolated
>> calls, but for thousands of scans you get thousands of small chunks of
>> memory.
>>
>> Does your test case get better if you insert corresponding pfree() calls?
>
> Yes -- I'd already checked.
Ok, I committed a fix that inserts some pfree() calls. Thanks for the
report.
From | Date | Subject | |
---|---|---|---|
Next Message | Nazir Bilal Yavuz | 2024-12-03 08:18:13 | Re: meson missing test dependencies |
Previous Message | Masahiro Ikeda | 2024-12-03 08:13:24 | Doc: fix the rewrite condition when executing ALTER TABLE ADD COLUMN |