Re: Time to up bgwriter_lru_maxpages?

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Time to up bgwriter_lru_maxpages?
Дата
Msg-id eee1e654-7cae-d189-cc9f-7f9e85e34f66@BlueTreble.com
обсуждение исходный текст
Ответ на Re: Time to up bgwriter_lru_maxpages?  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Time to up bgwriter_lru_maxpages?
Re: Time to up bgwriter_lru_maxpages?
Список pgsql-hackers
On 11/28/16 11:53 AM, Joshua D. Drake wrote:
> On 11/28/2016 11:40 AM, Jim Nasby wrote:
>> With current limits, the most bgwriter can do (with 8k pages) is 1000
>> pages * 100 times/sec = 780MB/s. It's not hard to exceed that with
>> modern hardware. Should we increase the limit on bgwriter_lru_maxpages?
>
> Considering a single SSD can do 70% of that limit, I would say yes.

Next question becomes... should there even be an upper limit?
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)



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

Предыдущее
От: Petr Jelinek
Дата:
Сообщение: Re: Logical Replication WIP
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: PSQL commands: \quit_if, \quit_unless