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 по дате отправления: