Re: [WIP] [B-Tree] Retail IndexTuple deletion

13.07.2018 00:00, Peter Geoghegan пишет:
> One area that might be worth investigating is retail index tuple
> deletion performed within the executor in the event of non-HOT
> updates.

I will try to use this idea. But now I developed a background worker 
already (experimental state). It clean an index and heap relations with 
a retail deletion approach.
It uses "soft" strategy with conditional buffer locks. Benchmarks on 
pgbench test demonstrate same execution time as PostgreSQL without the 
worker, but 90% of dead tuples in index and heap relations cleaned 
without vacuum.
My main efforts is involved to tuning of the worker.

---
Andrey Lepikhov
Postgres Professional
https://postgrespro.com
The Russian Postgres Company