bgwriter_lru_multiplier

Поиск
Список
Период
Сортировка
От Henry Francisco Garcia Cortez
Тема bgwriter_lru_multiplier
Дата
Msg-id CAJP2v3Hs5VA8pgcu5c7-ekokg6BiSBuj5maDFPRdi1iVnQYu9A@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
Hi community, I was reading about bgwriter_lru_multiplier I found it, that article said bgwriter_lru_multiplier is a multiplier ratio determining how many pages should be cleaned for incoming dirty pages, based on counts from last delay periods. For example, if the value is set to 2 and if incoming buffers pages are 10, dirty buffers will be cleaned until there are 20 buffers available or until bgwriter_lru_maxpages has been written. I have several questions:

First, When they say about  buffers cleaned that refers to bgwriter downloaded buffers dirty to hard disk
Second, where buffers should be available on shared buffers or in another place?
Third, if I decide to increase the ratio of bgwriter_lru_ multiplier, could my performance be affected?
Finally, if I set a value of 1000 on bgwriter_lru_maxpages, What is value do you recommend for bgwriter_lru_multiplier?

--
Ing. Henry G. Cortez



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

Предыдущее
От: Sergio Alonso
Дата:
Сообщение: Barman setup
Следующее
От: Scott Ribe
Дата:
Сообщение: system catalog performance