Re: [GENERAL] pgbench not setting scale size correctly? - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: [GENERAL] pgbench not setting scale size correctly?
Date
Msg-id 200805072138.m47LcoL17254@momjian.us
Whole thread Raw
Responses Re: [GENERAL] pgbench not setting scale size correctly?
Re: [GENERAL] pgbench not setting scale size correctly?
List pgsql-patches
Tom Lane wrote:
> Greg Smith <gsmith@gregsmith.com> writes:
> > On Fri, 14 Mar 2008, Tom Lane wrote:
> >> Yeah, -s is only meaningful when given with -i.  Maybe someday we ought
> >> to fix pgbench to complain if you try to set it at other times.
>
> > You have to pass -s in to the actual run if you're specifying your own
> > custom script(s) using -f and you want the :scale variable to be defined.
>
> Right, I knew that at one time ;-)
>
> > The way the option parsing code is done would make complaining in the case
> > where your parameter is ignored a bit of a contortion.  The part that
> > detects based on the database is after all the other parsing because the
> > connection has to be brought up first.
>
> Yeah.  But couldn't we have that part issue a warning if -s had been set
> on the command line?

Patch attached that issues a warning.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
Index: contrib/pgbench/pgbench.c
===================================================================
RCS file: /cvsroot/pgsql/contrib/pgbench/pgbench.c,v
retrieving revision 1.79
diff -c -c -r1.79 pgbench.c
*** contrib/pgbench/pgbench.c    19 Mar 2008 03:33:21 -0000    1.79
--- contrib/pgbench/pgbench.c    7 May 2008 21:36:42 -0000
***************
*** 1627,1632 ****
--- 1627,1635 ----
          }
      }

+     if (!is_init_mode && scale)
+         fprintf(stderr, "Scale specification ignored because init mode (-i) not specified\n");
+
      if (argc > optind)
          dbName = argv[optind];
      else

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [NOVICE] encoding problems
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] bug in numeric_power() function