Re: shared_buffers performance

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: shared_buffers performance
Дата
Msg-id 48046FC8.9030601@gmail.com
обсуждение исходный текст
Ответ на Re: shared_buffers performance  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-performance
Greg Smith wrote:
> On Mon, 14 Apr 2008, Gaetano Mendola wrote:
>
>> I'm using postgres 8.2.3 on Red Hat compiled with GCC 3.4.6.
>
> 8.2.3 has a performance bug that impacts how accurate pgbench results
> are; you really should be using a later version.
>
>> http://img84.imageshack.us/my.php?image=totalid7.png
>> as you can see using 64MB as value for shared_buffers I'm obtaining
>> better results.
>
> I'm assuming you've read my scaling article at
> http://www.westnet.com/~gsmith/content/postgresql/pgbench-scaling.htm
> since you're using the graph template I suggest there.
>

Yes I was basically inspired from that page, my true goal is not to study
the effect of shared_buffers (this was a side effect) but to study the
performance lose using DRBD on our server. I'm producing similar graph
using pgperf without -S, I will post them as soon they are ready.

Regards
Gaetano Mendola

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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: shared_buffers performance
Следующее
От: Bill Moran
Дата:
Сообщение: Re: db size