Re: Add pg_stat_vfdcache view for VFD cache statistics

From: David Geier <geidav(dot)pg(at)gmail(dot)com>
To: Ayoub Kazar <kazarayoub2004(at)gmail(dot)com>
Cc: KAZAR Ayoub <ma_kazar(at)esi(dot)dz>, Tomas Vondra <tomas(at)vondra(dot)me>, Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Add pg_stat_vfdcache view for VFD cache statistics
Date: 2026-09-08 16:33:18
Message-ID: b009d07a-e271-4eba-804c-d6a6b86dcc64@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>>> However, I'm wondering if the better approach wouldn't be to change fd.c
>>>> to use a long-lived memory context. Then all bookkeeping would happen
>>>> automatically and the memory size could simply be reported via existing
>>>> memory context stats infrastructure.
>>>>
>>>> Not entirely sure though if there's some roadblock when switching to a
>>>> memory context.
>>> I don't see any issue with this either. However, the only benefit we
>> would
>>> gain is using existing infrastructure but only for backend vfd cache
>> memory
>>> (i.e cache_bytes).
>>> Everything else stays the same (counters, cluster-wide memory);
>> therefore,
>>> if there's no other benefit to replacing with memory contexts, maybe it's
>>> not worth it.
>>
>> The biggest benefit in my view is consistency with the rest of PostgreSQL.
>> That is from a usage point of view as well as from a coding point of view.
>> If you want, I can give that a try and share a patch with you if
>> successful.
>>
> Yes of course, I’d be happy to take a look.
Attached is the patch. It's pretty small and passes regress tests.

--
David Geier

Attachment Content-Type Size
v1-0001-Vfd-cache-uses-memory-context-instead-of-malloc.patch text/plain 4.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Corey Huinker 2026-09-08 16:40:56 Re: Further cleanup related to statistics import support in postgres_fdw
Previous Message Greg Burd 2026-09-08 16:16:36 Re: Improve error handling in test modules: test_extensible, test_bitmapset