Hi, On 2021-01-20 09:24:35 +0530, Amit Kapila wrote: > I feel extending the deletion mechanism based on the number of LP_DEAD > items sounds more favorable than giving preference to duplicate > items. Sure, it will give equally good or better results if there are > no long-standing open transactions.
There's a lot of workloads that never set LP_DEAD because all scans are bitmap index scans. And there's no obvious way to address that. So I don't think it's wise to purely rely on LP_DEAD. Greetings, Andres Freund