Search Postgresql Archives

Partitions child tables and analyze

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Partitions child tables and analyze
From: Purchases <buy@xxxxxxxx>
Date: Thu, 9 Jan 2020 00:59:48 -1000

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?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Partitions child tables and analyze
  - From: Ravi Krishna

Prev by Date: Re: Upgrade PostgreSQL 9.6 to 10.6
Next by Date: Re: what to do after a failover
Previous by thread: How can I pushdown of functions used in targetlist with FDW ?
Next by thread: Re: Partitions child tables and analyze
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux