Re: Make recently inserted/updated records available in the buffer/cache
MichaelDBA <[email protected]> Tue, 3 Dec 2019 12:32:48 -0500
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
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.