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?
- Re: Frequetly updated partial index leads to bloat on ind... Michael Lewis
- Re: Frequetly updated partial index leads to bloat o... Tom Lane
- Re: Frequetly updated partial index leads to blo... Francisco Olarte
- Re: Frequetly updated partial index leads to blo... Tom Dearman
- Re: Frequetly updated partial index leads to... Peter Geoghegan
- Re: Frequetly updated partial index leads to bloat o... Peter Geoghegan