Re: Autovacuum on partitioned table (autoanalyze) - Mailing list pgsql-hackers

From yuzuko
Subject Re: Autovacuum on partitioned table (autoanalyze)
Date
Msg-id CAKkQ50_DWOiyxTFRaiprYE4UqHmxL4JDPNfxzmti6s6nz0i1uw@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum on partitioned table (autoanalyze)  (Daniel Gustafsson <daniel@yesql.se>)
Responses Re: Autovacuum on partitioned table (autoanalyze)
List pgsql-hackers
> On Wed, Jul 1, 2020 at 6:26 PM Daniel Gustafsson <daniel@yesql.se> wrote:
>
> > On 21 Apr 2020, at 18:21, yuzuko <yuzukohosoya@gmail.com> wrote:
>
> > I'll update the patch soon.
>
> Do you have an updated version to submit?  The previous patch no longer applies
> to HEAD, so I'm marking this entry Waiting on Author in the meantime.
>
Thank you for letting me know.
I attach the latest patch applies to HEAD.

I think there are other approaches like Tom's idea that Justin previously
referenced, but this patch works the same way as previous patches.
(tracks updated/inserted/deleted tuples and checks whether the partitioned
tables needs auto-analyze, same as nonpartitioned tables)
Because I wanted to be able to analyze partitioned tables by autovacuum
as a first step, and I think this approach is the simplest way to do it.

-- 
Best regards,
Yuzuko Hosoya
NTT Open Source Software Center

Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Default setting for enable_hashagg_disk (hash_mem)
Next
From: Anastasia Lubennikova
Date:
Subject: Proposal: Automatic partition creation