4 ms·
I'm speaking from experience with 9.1, I perhaps this has changed since (5+ years of dev!). I ran an experiment to demonstrate no XID reset on vacuum full: I r
by limaoscarjuliet 10y ago
I'm speaking from experience with 9.1, I perhaps this has changed since (5+ years of dev!). I ran an experiment to demonstrate no XID reset on vacuum full:
I ran a test:
XID age in callback 354015 (0% of max)
task=# vacuum full callback;
XID age in callback 354015 (0% of max)
task=# vacuum freeze callback;
XID age in callback 11 (0% of max)
- anarazel 10y agoYea, but that's not the same as not freezing at all - it freezes stuff older than autovacuum_freeze_min_age.