Re: shared_buffers performance - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: shared_buffers performance
Date
Msg-id 48046FC8.9030601@gmail.com
Whole thread Raw
In response to Re: shared_buffers performance  (Greg Smith <gsmith@gregsmith.com>)
List 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 by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: shared_buffers performance
Next
From: Bill Moran
Date:
Subject: Re: db size