> On Wed, Jul 1, 2020 at 6:26 PM Daniel Gustafsson <dan...@yesql.se> wrote: > > > On 21 Apr 2020, at 18:21, yuzuko <yuzukohos...@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
v8_autovacuum_on_partitioned_table.patch
Description: Binary data