Re: Partitions child tables and analyze
Ravi Krishna <[email protected]> Thu, 9 Jan 2020 11:05:22 -0500
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
>=20 > 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.