Re: pgbench vs. SERIALIZABLE

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: pgbench vs. SERIALIZABLE
Дата
Msg-id alpine.DEB.2.02.1305201904270.32000@localhost6.localdomain6
обсуждение исходный текст
Ответ на Re: pgbench vs. SERIALIZABLE  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
> I think it would be good to do it in pgbench, provided it can be done
> fairly cleanly.
>
> Presumably we would want to repeat all of the ordinary commands, in the
> file, but not any of the backslash set commands that precede any ordinary
> commands.  But what if backslash set commands are sprinkled between
> ordinary commands?

As I have spent some time in pgbench recently, ISTM that when restarting 
the transaction (reset state = 0), you want to keep track of the farthest 
state that was reached on previous attempts, so as to skip backslash 
commands for those states, and restart execute them where they were left. 
That would mean one integer for this purpose in the client structure.

-- 
Fabien



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Fast promotion failure
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: fast promotion and log_checkpoints