Re: Pgbench with -f and -S

From: Robins Tharakan <tharakan(at)gmail(dot)com>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Pgbench with -f and -S
Date: 2016-04-18 08:51:31
Message-ID: CAEP4nAzLHTy5B1ag4Ut_VBgrFh1X-rbxq5feuLziGx9=aGELJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cri(dot)ensmp(dot)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[(at)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2016-04-18 08:55:15 Re: Declarative partitioning
Previous Message Ashutosh Bapat 2016-04-18 08:43:11 Re: Declarative partitioning