Re: Faster pg_resore with autovacuum off?
| От | Ron Johnson |
|---|---|
| Тема | Re: Faster pg_resore with autovacuum off? |
| Дата | |
| Msg-id | CANzqJaDSZpGU-huoOTZnntaPBK+urn531k-MZOGMbdtL6u52yA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Faster pg_resore with autovacuum off? (Wells Oliver <wells.oliver@gmail.com>) |
| Ответы |
Re: Faster pg_resore with autovacuum off?
|
| Список | pgsql-admin |
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 по дате отправления: