Re: pgbench not setting scale size correctly?

From: Justin <justin(at)emproshunts(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pgbench not setting scale size correctly?
Date: 2008-03-14 18:45:47
Message-ID: 47DAC7DB.30508@emproshunts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches


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(at)gregsmith(dot)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) ???

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-03-14 19:40:45 Re: postgre vs MySQL
Previous Message A. Kretschmer 2008-03-14 18:44:30 Re: SQL UPDATE question

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2008-03-14 21:18:22 Re: Suppress compiler warnings on mingw
Previous Message Justin 2008-03-14 18:27:58 Re: pgbench not setting scale size correctly?