Re: More shared buffers causes lower performances

Поиск
Список
Период
Сортировка
Искать
От
Guillaume Smet
Тема
Re: More shared buffers causes lower performances
Дата
Msg-id
1d4e0c10712260455w7eda7fc1s4d23b43de5270152@mail.gmail.com
Ответ на
Список
Дерево обсуждения
More shared buffers causes lower performances "Guillaume Smet" <guillaume.smet@gmail.com>
Re: More shared buffers causes lower performances Simon Riggs <simon@2ndquadrant.com>
Re: More shared buffers causes lower performances "Guillaume Smet" <guillaume.smet@gmail.com>
Re: More shared buffers causes lower performances "Guillaume Smet" <guillaume.smet@gmail.com>
Re: More shared buffers causes lower performances "Pavel Stehule" <pavel.stehule@gmail.com>
Re: More shared buffers causes lower performances "Guillaume Smet" <guillaume.smet@gmail.com>
Re: More shared buffers causes lower performances Greg Smith <gsmith@gregsmith.com>
Re: More shared buffers causes lower performances "Guillaume Smet" <guillaume.smet@gmail.com>
Re: More shared buffers causes lower performances "Guillaume Smet" <guillaume.smet@gmail.com>
Re: More shared buffers causes lower performances Greg Smith <gsmith@gregsmith.com>
Re: More shared buffers causes lower performances Devrim GÜNDÜZ <devrim@CommandPrompt.com>
Re: More shared buffers causes lower performances Tom Lane <tgl@sss.pgh.pa.us>
Re: More shared buffers causes lower performances "Guillaume Smet" <guillaume.smet@gmail.com>
Re: More shared buffers causes lower performances Magnus Hagander <magnus@hagander.net>
Re: More shared buffers causes lower performances Alvaro Herrera <alvherre@commandprompt.com>
Re: More shared buffers causes lower performances Gregory Stark <stark@enterprisedb.com>
Re: More shared buffers causes lower performances Greg Smith <gsmith@gregsmith.com>
Re: More shared buffers causes lower performances Tom Lane <tgl@sss.pgh.pa.us>
Re: More shared buffers causes lower performances Alvaro Herrera <alvherre@commandprompt.com>
Re: More shared buffers causes lower performances Tom Lane <tgl@sss.pgh.pa.us>
Re: More shared buffers causes lower performances "Guillaume Smet" <guillaume.smet@gmail.com>
Re: More shared buffers causes lower performances Gregory Stark <stark@enterprisedb.com>
Re: More shared buffers causes lower performances Bruce Momjian <bruce@momjian.us>
Re: More shared buffers causes lower performances Cédric Villemain <cedric.villemain@dalibo.com>
Re: More shared buffers causes lower performances "Guillaume Smet" <guillaume.smet@gmail.com>
Re: More shared buffers causes lower performances "Merlin Moncure" <mmoncure@gmail.com>
On Dec 26, 2007 12:21 PM, Simon Riggs  wrote:
> Can you try with
>
> bgwriter_lru_maxpages = 0
>
> So we can see if the bgwriter has any hand in this?

I will. I'm currently running tests with less concurrent clients (16)
with exactly the same results:
64M 4213.314902
256M 4012.782820
512M 3676.840722
768M 3377.791211
1024M 2863.133965
64M again 4274.531310

I'm rerunning the tests using Greg Smith's pgbench-tools [1] to obtain
a graph of each run.

[1] http://www.westnet.com/~gsmith/content/postgresql/pgbench-tools.htm

--
Guillaume
В списке pgsql-performance по дате отправления
От: Guillaume Smet
Дата:
От: Fernando Hevia
Дата:
FAQ