Hi, On Tue, Jul 01, 2025 at 06:45:37PM +0200, Tomas Vondra wrote: > On 7/1/25 18:34, Bertrand Drouvot wrote: > > But isn't the _numa view good enough for this? Sure, you need NUMA > support for it, and it may take a fair amount of time, but how often you > need to do such queries?
Not that often, but my reasoning was more like: why people managing engines and/or developing on platform that does not support libnuma would not deserve access to this information? > I don't plan to block improving this use case, No worries at all, I do appreciate that you're looking at it and provide feedback whatever the outcome would be. > but I'm not sure it's worth the effort. I think that the hard work has already been done while creating pg_buffercache_numa_pages(). Now it's just a matter of extracting the necessary pieces from pg_buffercache_numa_pages() so that: * the new view could make use of it * the maintenance burden should be low (thanks to code dedeuplication) * people that don't have access to a platform that supports libnuma can have access to this information Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com
