Make recently inserted/updated records available in the buffer/cache

Поиск
Список
Период
Сортировка
От Sachin Divekar
Тема Make recently inserted/updated records available in the buffer/cache
Дата
Msg-id CA+A8H7mJiWaohQv0k6Fv2i-nuRKyzDKu-J8vwp_DS72=zL-eCw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Make recently inserted/updated records available in the buffer/cache  (Hüseyin Demir <demirhuseyinn.94@gmail.com>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Aufar Gilbran
Дата:
Сообщение: [External] Join queries slow with predicate, limit, and ordering
Следующее
От: Hüseyin Demir
Дата:
Сообщение: Re: Make recently inserted/updated records available in the buffer/cache