3 ms·
I think that's a false warning from pgAdmin. In general, if you don't have extremely high UPDATE rates (thousands per second) you don't really need to care abo
by hans_castorp 6y ago
I think that's a false warning from pgAdmin.
In general, if you don't have extremely high UPDATE rates (thousands per second) you don't really need to care about vacuum these days (assuming you correctly end all your transactions and don't have any sessions in "idle in transaction" for a long time)
- jhoechtl 6y agoAdding to that comment: You can tweak the times where automatic VACUUMing happens to a certain degree, https://www.postgresql.org/docs/12/runtime-config-autovacuum.html https://www.postgresql.org/docs/12/runtime-config-autovacuum...