Re: Make recently inserted/updated records available in thebuffer/cache

Поиск
Список
Период
Сортировка
От MichaelDBA
Тема Re: Make recently inserted/updated records available in thebuffer/cache
Дата
Msg-id 33edd9ba-5ab8-f7d1-6376-4046f9ba6d9f@sqlexec.com
обсуждение исходный текст
Ответ на Re: Make recently inserted/updated records available in the buffer/cache  (Michael Lewis <mlewis@entrata.com>)
Ответы Re: Make recently inserted/updated records available in the buffer/cache  (Sachin Divekar <ssd532@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Yep, I concur completely!  For tables treated like queues you gotta do 
this stuff or deal with bloat and fragmented indexes.

Michael Lewis wrote on 12/3/2019 12:29 PM:
> "I am going to use it as a queue"
>
> You may want to look at lowering fillfactor if this queue is going to 
> have frequent updates, and also make autovacuum/analyze much more 
> aggressive assuming many updates and deletes.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Make recently inserted/updated records available in the buffer/cache
Следующее
От: Sachin Divekar
Дата:
Сообщение: Re: Make recently inserted/updated records available in the buffer/cache