On Wed, 2022-04-20 at 23:06 +0000, senor wrote:
> I'm apparently needing an education on how this "to avoid wraparound" vacuum differs from
> any other. I've seen it referenced as "more aggressive" but I'd like details.
The difference is twofold, as far as I know:
- it will not skip any pages just because it happens not to get a lock on them
- it will refuse to die if the lock it holds on the table conflicts with a user lock
Unless you are in the habit of taking strong locks on the table, you shouldn't
notice a difference. Anti-wraparound VACUUM is a routine activity and does not
interfere with DML, just like a normal VACUUM.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com