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(at)gmail(dot)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.
>
> regards
> Sachin
>

--

*Hüseyin DEMİR*

IT SOLUTION ARCHITECT

0534-614-72-06
demirhuseyinn(dot)94(at)gmail(dot)com

selfarrival.blogspot.com.tr