Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Geoghegan
Subject Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Date
Msg-id CAH2-WzkO1f=_qmXwjA_espqCeY2PasDNH6f-rrRpTF8ENc4K2A@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 
> On Thu, Mar 18, 2021 at 6:51 AM Tom Dearman <tom.dearman@gmail.com> wrote:
> Is this a known issue, are they any ways around it, and if it is an
> issue is there a plan to fix it if a fix is possible?

On second thought I do think that the improvements to 14 will fix this
for you. See the test case here:


https://www.postgresql.org/message-id/flat/CAL9smLC%3DSxYiN7yZ4HDyk0RnZyXoP2vaHD-Vg1JskOEHyhMXug%40mail.gmail.com#e79eca5922789de828314e296fdcb82d

--
Peter Geoghegan

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Using XMLNAMESPACES with XMLEMENT
Next
From: Pavel Stehule
Date:
Subject: Re: Using XMLNAMESPACES with XMLEMENT