Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Frequetly updated partial index leads to bloat on index for Postresql 11
From: Michael Lewis <mlewis@xxxxxxxxxxx>
Date: Fri, 16 Jul 2021 08:49:27 -0600
Cc: Peter Geoghegan <pg@xxxxxxx>, pgsql-general General <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <95D506BA-D1E8-45BB-8167-BD61ED3D9B9C@gmail.com>
References: <CAGRwtPy0stc_XSuWdxis7GtvVUV2=xWjsd-g4hjzOSaTi5L72A@mail.gmail.com> <CAH2-WzmoZBJXYcaBKt2Zjyy-RXiHRsCQyXTcZKiB+n1C4kteTw@mail.gmail.com> <95D506BA-D1E8-45BB-8167-BD61ED3D9B9C@gmail.com>

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?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Frequetly updated partial index leads to bloat on index for Postresql 11
  - From: Tom Dearman

References:
- Frequetly updated partial index leads to bloat on index for Postresql 11
  - From: Tom Dearman
- Re: Frequetly updated partial index leads to bloat on index for Postresql 11
  - From: Peter Geoghegan
- Re: Frequetly updated partial index leads to bloat on index for Postresql 11
  - From: Tom Dearman

Prev by Date: Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Next by Date: Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Previous by thread: Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Next by thread: Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]