quick q re migration, index, stats

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: quick q re migration, index, stats
Date: 2021-01-06 16:41:40
Message-ID: 8DB33DAF-479F-487F-924A-3360676D8103@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

As part of migration to PG 13, I'll be updating Linux as well, thus complete reindex required.

So just confirming that I still need to manually run vacuumdb --all --analyze-in-stages? In other words, reindexing doesn't capture stats as it processes the rows?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Henry Francisco Garcia Cortez 2021-01-06 17:05:41 autovacuum_analyze_scale_factor and autovacuum_analyze_scale_factor
Previous Message Sushant Pawar 2021-01-06 15:03:41 Re: Logical replication use cases