Re: Make recently inserted/updated records available in thebuffer/cache

Поиск
Список
Период
Сортировка
От MichaelDBA
Тема Re: Make recently inserted/updated records available in thebuffer/cache
Дата
Msg-id d9916d03-8ba1-4e83-816e-2a6157161cce@sqlexec.com
обсуждение исходный текст
Ответ на Re: Make recently inserted/updated records available in the buffer/cache  (Hüseyin Demir <demirhuseyinn.94@gmail.com>)
Ответы Re: Make recently inserted/updated records available in the buffer/cache  (Michael Lewis <mlewis@entrata.com>)
Список pgsql-performance
All updated/dirty records go through PG internal memory buffer, 
shared_buffers.  Make sure that is configured optimally.  Use 
pg_buffercache extension to set it correctly.

Regards,
Michael Vitale

Hüseyin Demir wrote on 12/2/2019 12:13 PM:
> I guess there won't be any adverse effect




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

Предыдущее
От: Hüseyin Demir
Дата:
Сообщение: Re: Make recently inserted/updated records available in the buffer/cache
Следующее
От: Eugene Podshivalov
Дата:
Сообщение: Re: Considerable performance downgrade of v11 and 12 on Windows