Hello, I'm working on a high volume transaction database and we are starting to tune our autovacuum setting to improve our vacuuming performance.
Once thing that we know about autovacuum is that is can be automatically canceled if a dependent transaction is blocked by the autovacuum transaction. In a situation like this one, autovacuum would be canceled. My question is, what will happen to the work that autovacuum has achieved before being canceled ? Is that work lost ? I tried to look for the answer in the code and I'm not completely sure what will happen. From what I could understand (that can be totally wrong), the vacuum process is split in multiple small transactions. If the autovacuum is canceled, could it be possible that only the latest transaction work be lost ? Sorry if my understanding is not the correct one, understanding how to tune the autovacuum seems really complicated to me. Thanks before hand! Martín
