Postgres Pro
Downloads
Home   >   mailing lists

Re: Faster pg_resore with autovacuum off? - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Faster pg_resore with autovacuum off?
Date
Msg-id CANzqJaDSZpGU-huoOTZnntaPBK+urn531k-MZOGMbdtL6u52yA@mail.gmail.com
Whole thread Raw
In response to Re: Faster pg_resore with autovacuum off?  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Faster pg_resore with autovacuum off?
List pgsql-admin
Tree view
It's obvious why unanalyzed tables could cause materialization to be slow, but why would unvacuumed tables cause slowness when creating materialized views?

Also, how can you be sure that the underlying tables have been analyzed before pg_restore gets to the CREATE MATERIALIZED VIEW statements?

On Sun, Jul 28, 2024 at 12:36 PM Wells Oliver <wells.oliver@gmail.com> wrote:
fwiw, we have a lot of materialized views, so restoring a DB on non-vacuumed tables caused the materialization to take a lot longer than it would have with autovacuum running as normal. Seems worth experimenting though.
 

pgsql-admin by date:

Previous
From: Wasim Devale
Date:
Subject: Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
Next
From: Brock Henry
Date:
Subject: Re: Stream pg_dumpall directly from CentOS7 to Red Hat server