analyze partition - Mailing list pgsql-general

From Marc Millas
Subject analyze partition
Date
Msg-id CADX_1aYtZ811YiUcEPGMpMYA0gzBCP4giNJONhZaJueTijxL3g@mail.gmail.com
Whole thread Raw
Responses Re: analyze partition
List pgsql-general
Hi,

the documentation, on chapter 5.11.3.3 caveat  says that a manual vacuum or analyze on the root table does it only for that said root table. To my understanding, the root table when used with declarative partitioning, does not contain data, so vacuuming or analyzing should be 'fast'.
If I run vacuum analyze ma_table on my big partitioned table (130+ partitions) it does work for quite a long time.

Can someone clarify ?

thanks


Marc MILLAS
Senior Architect
+33607850334

pgsql-general by date:

Previous
From: Marc Millas
Date:
Subject: Re: need explanation about an explain plan
Next
From: jian he
Date:
Subject: Re: analyze partition