Limit of bgwriter_lru_maxpages of max. 1000?
От | Gerhard Wiesinger |
---|---|
Тема | Limit of bgwriter_lru_maxpages of max. 1000? |
Дата | |
Msg-id | alpine.LFD.2.00.0909270731120.21738@bbs.intern обсуждение исходный текст |
Ответы |
Re: Limit of bgwriter_lru_maxpages of max. 1000?
|
Список | pgsql-general |
Hello, I think the limit of bgwriter_lru_maxpages of max. 1000 doesn't make any sense because in fact it limits performance of the database (version 8.3). On heavy write operations buffer cached must be freed. With the default config this is practically limited to: bgwriter_delay=200ms bgwriter_lru_maxpages=100 8k*bgwriter_lru_maxpages*1000/bgwriter_delay= =8k*100*1000/200=4000k=4MB/s Isn't that a major performancd bottleneck in default config? bgwriter_delay=200ms bgwriter_lru_maxpages=1000 8k*bgwriter_lru_maxpages*1000/bgwriter_delay= =8k*1000*1000/200=40000k=40MB/s Still not a very high number for current I/O loads. Lowering bgwriter_delay is possible, but I think overhead is too much and still there is a limit of 800MB/s involved: bgwriter_delay=10ms bgwriter_lru_maxpages=1000 8k*bgwriter_lru_maxpages*1000/bgwriter_delay= =8k*1000*1000/10=800000k=800MB/s So I think it would be better to have such a configuration: bgwriter_delay=50ms bgwriter_lru_maxpages=100000 8k*bgwriter_lru_maxpages*1000/bgwriter_delay= =8k*100000*1000/50=16000000k=16000MB/s So in fact I think bgwriter_lru_maxpages should be limited to 100000 if limited at all. Are my argumentations correct? Any comments? Thnx. Ciao, Gerhard -- http://www.wiesinger.com/
В списке pgsql-general по дате отправления: