Re: Partitions child tables and analyze - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Partitions child tables and analyze
Date
Msg-id F4C1CF31-B44C-49CF-A50E-F95AC33218E0@vivaldi.net
Whole thread Raw
In response to Partitions child tables and analyze  (Purchases <buy@mark.net>)
List pgsql-general
>
> If rows are added, deleted etc from specific child tables of a partition is it necessary when performing an analyze
toanalyze the entire partition or just the children that experienced the row changes? 

Under the hood each partition is a separate table, so why is analyzing entire parent table necessary.




pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Is it safe to transfer logical replicationpublication/subscription?
Next
From: Stephen Frost
Date:
Subject: Re: How can I pushdown of functions used in targetlist with FDW ?