Re: pgbench not setting scale size correctly?

On Fri, 14 Mar 2008, Justin wrote:

> I was wondering why the -s would not rescale the data?

First, you don't know how to rescale the data if someone is passing in a
custom script. More importantly, people don't expect the benchmark tool
to change things in tables unless specifically requested. I once made the
unfortunate mistake of running 'pgbench -i' against the wrong database,
one that just happened to have a table named 'accounts' in it, only to
watch that table get destroyed. It would be unwise to make that behavior
easier to trigger.

pgbench is a fairly flexible tool that supports creating simple scripted
tests for a variety of purpose. It just so happens that most people only
ever use the default tests where it seems things could be simplified.
They could, but it would take some of the flexibility out as well.

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