Laurenz Albe <laurenz.albe@xxxxxxxxxxx> writes: > But from PostgreSQL v13 on, autovacuum is also triggered by INSERTs. > So I'd say that there is nothing to do after restoring a pg_dump, except > to wait until autovacuum is done. You might want to do manual VACUUM ANALYZE (no need for FULL) if you don't want to wait around for autovacuum to get to it. regards, tom lane
