Make recently inserted/updated records available in the buffer/cache
Sachin Divekar <[email protected]> Mon, 2 Dec 2019 22:33:03 +0530
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CA+A8H7mJiWaohQv0k6Fv2i-nuRKyzDKu-J8vwp_DS72=zL-eCw@mail.gmail.com> |
Hi, I am looking for tuning my PG setup such that recently inserted or updated record will be available in the buffer/cache (I believe they are same in this context). Does PostgreSQL do it by default? If yes, just increasing buffer size sufficient? What will be its effect on LRU performance -- I guess there won't be any adverse effect? My use case is that I am going to use it as a queue and performance will be dependent upon whether the recently updated record is available in the cache. Thank you. regards Sachin