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

From Justin
Subject Re: pgbench not setting scale size correctly?
Date
Msg-id 47DAC7DB.30508@emproshunts.com
Whole thread Raw
In response to Re: pgbench not setting scale size correctly?  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
Greg Smith wrote:
> 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
>
OK,  what if it warns on the -s is set  when missing -i and when ( -i
and -f is set in the same command) ???

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Unexpected error in grant/revoke script
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: Can't rename an existnig DB because it doesn't exist???