Re: Pgbench with -f and -S

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: Pgbench with -f and -S
Дата
Msg-id alpine.DEB.2.10.1604171734190.23313@sto
обсуждение исходный текст
Ответ на Pgbench with -f and -S  (Robins Tharakan <tharakan@gmail.com>)
Ответы Re: Pgbench with -f and -S
Список 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 по дате отправления:

Предыдущее
От: David Steele
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Move PinBuffer and UnpinBuffer to atomics