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
<div dir="ltr">Got it. Thanks for explaining that. Was looking at -S earlier and didn't notice the new -b and @ weight
optionsin 9.6devel.</div><br /><div class="gmail_quote"><div dir="ltr">On Mon, 18 Apr 2016 at 10:54 Fabien COELHO
<<ahref="mailto:coelho@cri.ensmp.fr">coelho@cri.ensmp.fr</a>> wrote:<br /></div><blockquote class="gmail_quote"
style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br /> >> For the future 9.6, scripts
optionsare cumulatives, so -f & -S can be<br /> >> combined.<br /> >><br /> >> Indeed, for the
<=9.5 it seems that some options are silently ignores,<br /> >> when combining -S/-f, only the last one is
kept,it should be warned about.<br /> > ​<br /> > ​Thanks Fabien, for confirming about the missing warning.<br />
><br/> > Also, by 'combined' I think you mean that both (built-in SELECTs & Custom<br /> > Script) run,
althoughthe dev docs don't (yet) say anything about that.<br /><br /> Hmmm... I think it does implicitely, with "add"
and"and" in the<br /> following:<br /><br /> From <a href="http://www.postgresql.org/docs/devel/static/pgbench.html"
rel="noreferrer"target="_blank">http://www.postgresql.org/docs/devel/static/pgbench.html</a>:<br /><br />    -b
scriptname[@weight]<br/>    Add the specified builtin script to the list of executed scripts. [...]<br /><br /> Idem
-f.<br/><br /> And later at the beginning of the Notes:<br /><br />    pgbench executes test scripts chosen randomly
froma specified list.<br />    They include built-in scripts with -b and user-provided custom scripts with -f.<br />  
 [...]<br/><br /> --<br /> Fabien.</blockquote></div><div dir="ltr">-- <br /></div><div dir="ltr"><p dir="ltr">-<br />
robins</div>

pgsql-hackers by date:

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