Re: pgbench enhancements

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: pgbench enhancements
Дата
Msg-id 20060726.202419.85390688.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответ на pgbench enhancements  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Ответы Re: pgbench enhancements
Список pgsql-hackers
> I have committed contrib/pgbench enhanments contributed by Tomoaki
> Sato from SRA OSS, Inc. Japan.
> 
> - predefined variable "tps"
>   The value of variable tps is taken from the scaling factor
>   specified by -s option.
> 
> - -D option
>   Variable values can be defined by -D option.
> 
> - \set command now allows arithmetic calculations.
> 
> enjoy,

BTW, running long benchmark using pgbench on BIG tables easily causes
an integer overflow error in following SQLs:

update accounts set abalance = abalance + :delta where aid = :aid;

update tellers set tbalance = tbalance + :delta where tid = :tid;

update branches set bbalance = bbalance + :delta where bid = :bid;

I'm inclined to change abalance, tbalance and bbalance column to
BIGINT to avoid the error. Opinion?
--
Tatsuo Ishii
SRA OSS, Inc. Japan


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