Re: pgsql: autovacuum: handle analyze for partitioned tables

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: autovacuum: handle analyze for partitioned tables
Date: 2021-04-08 20:11:49
Message-ID: 20210408201149.GA32386@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On 2021-Apr-08, Tom Lane wrote:

> > So I tend to think that my initial instinct was the better direction: we
> > should not be doing any find_all_inheritors() here at all, but instead
> > rely on pg_class.reltuples to be set for the partitioned table.
>
> +1

This patch does that.

--
Álvaro Herrera 39°49'30"S 73°17'W
"I dream about dreams about dreams", sang the nightingale
under the pale moon (Sandman)

Attachment Content-Type Size
0001-Set-pg_class.reltuples-for-partitioned-tables.patch text/x-diff 5.4 KB

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Zhihong Yu 2021-04-08 20:25:24 Re: pgsql: autovacuum: handle analyze for partitioned tables
Previous Message Peter Geoghegan 2021-04-08 19:55:25 pgsql: Silence another _bt_check_unique compiler warning.

Browse pgsql-hackers by date

  From Date Subject
Next Message Zhihong Yu 2021-04-08 20:25:24 Re: pgsql: autovacuum: handle analyze for partitioned tables
Previous Message Robert Haas 2021-04-08 20:07:53 Re: [HACKERS] Custom compression methods