Postgres Pro
Downloads
Home   >   mailing lists

Re: Frequetly updated partial index leads to bloat on index for Postresql 11 - Mailing list pgsql-general

From Michael Lewis
Subject Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Date
Msg-id CAHOFxGqP_SgWhZ7ZAts8DMQTKdP_7=T0XJiF2XosZJJWii84+g@mail.gmail.com
Whole thread Raw
In response to Re: Frequetly updated partial index leads to bloat on index for Postresql 11  (Tom Dearman <tom.dearman@gmail.com>)
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: Tom Dearman
Date:
Subject: Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Next
From: Tom Dearman
Date:
Subject: Re: Frequetly updated partial index leads to bloat on index for Postresql 11