News for hackers. Stuff that matters.

A comment on Improved vacuum in PostgreSQL 13. Parent comment

Re:Improved vacuum in PostgreSQL 13 by hans_castorp on Tuesday May 12, 2020 @03:29AM (#23151391)
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)

[ Parent | on HN ]
Re:Improved vacuum in PostgreSQL 13 by jhoechtl on Tuesday May 12, 2020 @03:42AM (#23151459)
Adding 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...

[ Parent | on HN ]