| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: pg_dump: VACUUM and REINDEXING |
| Date: | 2022-05-09 14:08:27 |
| Message-ID: | 3742514.1652105307@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sandeep Kumar Jakkaraju | 2022-05-09 16:07:57 | Re: Need to install Postgres Version 14 in Linux server with Client and migration steps. |
| Previous Message | Durumdara | 2022-05-09 11:27:30 | Re: PLPGSQL - extra column existence in trigger |