Re: Make recently inserted/updated records available in the buffer/cache
Hi,
PostgreSQL decides which pages should be evicted from memory and written to disk with the help of LRU algorithm. Thus, it depends on your query work load. In OLTP systems, the algorithm is beneficial to business requirements(almost :) )
It's hard to figure out that a configuration change will affect the performance in a good way. Maybe, you can use PostgreSQL warmup features in order to make sure the data pages that you need will be available in cache.
Because the results of LRU algorithm can vary depending on your business and system workload.
Best Regards.
Sachin Divekar <ssd532@gmail.com>, 2 Ara 2019 Pzt, 20:03 tarihinde şunu yazdı:
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.regardsSachin
Hüseyin DEMİR |
IT SOLUTION ARCHITECT |
|
В списке pgsql-performance по дате отправления:
Предыдущее
От: Sachin DivekarДата:
Сообщение: Make recently inserted/updated records available in the buffer/cache
Следующее
От: MichaelDBAДата:
Сообщение: Re: Make recently inserted/updated records available in thebuffer/cache