Home > mailing lists

Re: Vacuum and Materialized view refresh slow - Mailing list pgsql-general

From	Rob Sargent
Subject	Re: Vacuum and Materialized view refresh slow
Date	December 1, 2018 00:00:11
Msg-id	33cd6b11-f3a6-56f1-4512-8afd18792598@gmail.com Whole thread Raw
In response to	Re: Vacuum and Materialized view refresh slow (Rene Romero Benavides <rene.romero.b@gmail.com>)
List	pgsql-general

On 11/30/18 1:53 PM, Rene Romero Benavides wrote:

Have you benchmarked the new infrastructure's IO and network performance? why did you switch providers? was it because of cost?

And have you proven to yourself that all the indices are in place, stats are up-to-date? You didn't by any chance migrate away from SSD?

From: Rene Romero Benavides
Date: 30 November 2018, 23:53:45
Subject: Re: Vacuum and Materialized view refresh slow

From: Adrian Klaver
Date: 01 December 2018, 00:55:42
Subject: Re: Dump table using pg_dump vs pg_restore -f