Re: Frequetly updated partial index leads to bloat on index for Postresql 11

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Tom Dearman <tom(dot)dearman(at)gmail(dot)com>
Cc: Peter Geoghegan <pg(at)bowt(dot)ie>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Date: 2021-07-16 14:49:27
Message-ID: CAHOFxGqP_SgWhZ7ZAts8DMQTKdP_7=T0XJiF2XosZJJWii84+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Dearman 2021-07-16 14:58:01 Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Previous Message Tom Dearman 2021-07-16 14:24:01 Re: Frequetly updated partial index leads to bloat on index for Postresql 11