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@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general