Re: Partitions child tables and analyze

From: Ravi Krishna <srkrishna(at)vivaldi(dot)net>
To: Purchases <buy(at)mark(dot)net>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Partitions child tables and analyze
Date: 2020-01-09 16:05:22
Message-ID: F4C1CF31-B44C-49CF-A50E-F95AC33218E0@vivaldi.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?

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pepe TD Vo 2020-01-09 17:06:43 partitioned table
Previous Message Peter Eisentraut 2020-01-09 15:52:53 Re: Is it safe to transfer logical replication publication/subscription?