Partitions child tables and analyze

From: Purchases <buy(at)mark(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Partitions child tables and analyze
Date: 2020-01-09 10:59:48
Message-ID: 41D97F4D-B669-4FCD-954A-673B789C3671@mark.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If rows are added, deleted etc from specific child tables of a partition is it necessary when performing an analyze to analyze the entire partition or just the children that experienced the row changes?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rita 2020-01-09 11:55:18 Re: what to do after a failover
Previous Message Michael Lewis 2020-01-09 05:02:38 Re: Upgrade PostgreSQL 9.6 to 10.6