Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows

Поиск
Список
Период
Сортировка
От Tsunakawa, Takayuki
Тема Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows
Дата
Msg-id 0A3221C70F24FB45833433255569204D1F64F955@G01JPEXMBYT05
обсуждение исходный текст
Ответ на Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
Ответы Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows
Список pgsql-hackers
From: Tsunakawa, Takayuki/綱川 貴之
> Thank you, I'll try the read-write test with these settings on the weekend,
> when my PC is available.  I understood that your intention is to avoid being
> affected by checkpointing and WAL segment creation.

The result looks nice as follows.  I took the mean value of three runs.

shared_buffers  tps
256MB  990
512MB  813
1GB  1189
2GB  2258
4GB  5003
8GB  5062

"512MB is the largest effective size" seems to be a superstition, although I don't know the reason for the drop at
512MB.


Regards
Takayuki Tsunakawa



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: amcheck (B-Tree integrity checking tool)
Следующее
От: Corey Huinker
Дата:
Сообщение: dblink get_connect_string() passes FDW option "updatable" to the connect string, connection fails.