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]