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

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Дата
Msg-id CAH2-WzkO1f=_qmXwjA_espqCeY2PasDNH6f-rrRpTF8ENc4K2A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Frequetly updated partial index leads to bloat on index for Postresql 11  (Tom Dearman <tom.dearman@gmail.com>)
Список pgsql-general
Дерево обсуждения 
> 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 по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Using XMLNAMESPACES with XMLEMENT
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Using XMLNAMESPACES with XMLEMENT