Re: Make recently inserted/updated records available in thebuffer/cache - Mailing list pgsql-performance

From MichaelDBA
Subject Re: Make recently inserted/updated records available in thebuffer/cache
Date
Msg-id 33edd9ba-5ab8-f7d1-6376-4046f9ba6d9f@sqlexec.com
Whole thread Raw
In response to Re: Make recently inserted/updated records available in the buffer/cache  (Michael Lewis <mlewis@entrata.com>)
Responses Re: Make recently inserted/updated records available in the buffer/cache  (Sachin Divekar <ssd532@gmail.com>)
List 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 by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Make recently inserted/updated records available in the buffer/cache
Next
From: Sachin Divekar
Date:
Subject: Re: Make recently inserted/updated records available in the buffer/cache