Re: pgbench not setting scale size correctly? - Mailing list pgsql-general

From Greg Smith
Subject Re: pgbench not setting scale size correctly?
Date
Msg-id Pine.GSO.4.64.0803141306450.10455@westnet.com
Whole thread Raw
In response to Re: pgbench not setting scale size correctly?  (Justin <justin@emproshunts.com>)
Responses Re: pgbench not setting scale size correctly?  (Justin <justin@emproshunts.com>)
List pgsql-general
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@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgbench not setting scale size correctly?
Next
From: Justin
Date:
Subject: Re: pgbench not setting scale size correctly?