Re: Use heap scan routines directly in vac_update_datfrozenxid()

2024-10-07 Thread Alvaro Herrera
On 2024-Oct-06, Tom Lane wrote: > Soumyadeep Chakraborty writes: > > Attached is a simple patch to directly use heap scan routines in > > vac_update_datfrozenxid(), avoiding the multilayer overhead from the > > sysscan infrastructure. Though if there's anybody with a Postgres fork using catalog

Re: Use heap scan routines directly in vac_update_datfrozenxid()

2024-10-06 Thread Tom Lane
Soumyadeep Chakraborty writes: > Attached is a simple patch to directly use heap scan routines in > vac_update_datfrozenxid(), avoiding the multilayer overhead from the > sysscan infrastructure. I would think the overhead of that is minuscule. If it isn't, we should try to make it so, not random

Use heap scan routines directly in vac_update_datfrozenxid()

2024-10-06 Thread Soumyadeep Chakraborty
Hi hackers, Attached is a simple patch to directly use heap scan routines in vac_update_datfrozenxid(), avoiding the multilayer overhead from the sysscan infrastructure. The speedup can be noticeable in databases containing a large number of relations (perhaps due to heavy partition table usage).