We have change autovacuum so that it runs more frequently autovacuum_vacuum_scale_factor=0.035, the reason we have a partial index on the status is that in a table of 300 million entries, only about 100 or so would have status=‘IN_PROGRESS’ so we think this should be a nice small index and many of our queries want to look up with a where clause status=‘IN_PROGRESS’. In theory it works well, but we get a lot of index bloat as there is a lot of churn on the status value, ie each row starts as IN_PROGRESS and then goes to one of 4 possible completed statuses.
> On 16 Jul 2021, at 15:49, Michael Lewis <mle...@entrata.com> wrote: > > Have you tried setting autovacuum to run quite aggressively, perhaps just on > this table? Have you tried an index on the status column only, rather than > partial?