Re: Pgbench with -f and -S - Mailing list pgsql-hackers

From Robins Tharakan
Subject Re: Pgbench with -f and -S
Date
Msg-id CAEP4nAzLHTy5B1ag4Ut_VBgrFh1X-rbxq5feuLziGx9=aGELJA@mail.gmail.com
Whole thread Raw
In response to Re: Pgbench with -f and -S  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
Got it. Thanks for explaining that. Was looking at -S earlier and didn't notice the new -b and @ weight options in 9.6devel.

On Mon, 18 Apr 2016 at 10:54 Fabien COELHO <coelho@cri.ensmp.fr> wrote:

>> For the future 9.6, scripts options are cumulatives, so -f & -S can be
>> combined.
>>
>> Indeed, for the <= 9.5 it seems that some options are silently ignores,
>> when combining -S/-f, only the last one is kept, it should be warned about.
> ​
> ​Thanks Fabien, for confirming about the missing warning.
>
> Also, by 'combined' I think you mean that both (built-in SELECTs & Custom
> Script) run, although the dev docs don't (yet) say anything about that.

Hmmm... I think it does implicitely, with "add" and "and" in the
following:

From http://www.postgresql.org/docs/devel/static/pgbench.html:

   -b scriptname[@weight]
   Add the specified builtin script to the list of executed scripts. [...]

Idem -f.

And later at the beginning of the Notes:

   pgbench executes test scripts chosen randomly from a specified list.
   They include built-in scripts with -b and user-provided custom scripts with -f.
   [...]

--
Fabien.
--

-
robins

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Declarative partitioning
Next
From: Amit Langote
Date:
Subject: Re: Declarative partitioning