Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump: VACUUM and REINDEXING - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump: VACUUM and REINDEXING
Date
Msg-id 3742514.1652105307@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump: VACUUM and REINDEXING  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view 
Laurenz Albe <laurenz.albe@cybertec.at> 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

pgsql-general by date:

Previous
From: Durumdara
Date:
Subject: Re: PLPGSQL - extra column existence in trigger
Next
From: Sandeep Kumar Jakkaraju
Date:
Subject: Re: Need to install Postgres Version 14 in Linux server with Client and migration steps.