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

From Fabien COELHO
Subject Re: Pgbench with -f and -S
Date
Msg-id alpine.DEB.2.10.1604171734190.23313@sto
Whole thread Raw
In response to Pgbench with -f and -S  (Robins Tharakan <tharakan@gmail.com>)
Responses Re: Pgbench with -f and -S  (Robins Tharakan <tharakan@gmail.com>)
List pgsql-hackers
> Pgbench allows -f and -S combinations together where the doc says that -S
> effectively uses the internal select-only script.
>
> Is it okay to assume that -f is disregarded here? Or are they run in
> round-robin fashion (although then, how does it know which read-only part
> of my script to run?) or something else like that?
>
> Effectively, I think it should raise NOTICE that -f is useless here.

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.

-- 
Fabien.



pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <
Next
From: Amit Kapila
Date:
Subject: Re: Move PinBuffer and UnpinBuffer to atomics