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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
