Skip index cleanup if autovacuum did not do any work
Feike Steenbergen <feikesteenbergen@gmail.com>
From: Feike Steenbergen <feikesteenbergen@gmail.com>
To: PostgreSQL mailing lists <pgsql-hackers@postgresql.org>
Date: 2017-11-28T21:36:05Z
Lists: pgsql-hackers
Attachments
- 0001-skip_cleanup_for_stale_relation.patch (application/octet-stream)
On a server with a very frequent xid wraparound I can see that the anti-wraparound vacuum is finished very quickly with the heap, yet it still scans all the indexes, which causes it to still have to read a lot of data, which takes a considerable amount of time. I dove into the code a bit and as far as I can tell, all the time spent for doing this is is in lazy_cleanup_index. For the very specific use case of all-frozen, basically read-only tables, would it be ok to skip the lazy_cleanup_index call? As we are sure we did not touch the heap or the index, I'd say a cleanup may not be necessary. For this very specific usecase I would like to discuss whether or not this is a sane and/or good idea. regards, Feike