Re: postgresql 8.3 tps rate

On Thu, 22 Jan 2009, Alvaro Herrera wrote:

> Also, I think you should set the "scale" in the prepare step (-i) at
> least as high as the number of clients you're going to use. (I dimly
> recall some recent development in this area that might mean I'm wrong.)

The idea behind that maxim (clients>=scale) is that locking on the smaller
tables will bottleneck resuls if you don't follow that advice. It's a bit
messier than that though. Increasing the scale will also make the
database larger, and once it gets bigger than available RAM your results
are going to dive hard because of that, more so than the locking would
have held you back.

All kind of irrelevant for Ibrahim's case, because if you're not getting
more than 50MB/s out of your disks the pgbench results are kind of moot
anyway--there's a larger problem to sort out first.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD