Re: Make recently inserted/updated records available in the buffer/cache
Michael Lewis <[email protected]> Tue, 3 Dec 2019 10:29:18 -0700
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CAHOFxGozXOq=6Q1UOWi5=L1bvNvke_Rn+U-nm6FruxM-F61tSQ@mail.gmail.com> |
"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.