Re: pgbench hard coded constants

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: ishii(at)postgresql(dot)org
Cc: jeff(dot)janes(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pgbench hard coded constants
Date: 2009-09-10 14:00:52
Message-ID: 20090910.230052.108740205.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > pgbench has #defines for number of branches, tellers, and accounts. There
> > are used to populate the tables with -i, but when running actual benchmark
> > it has values separately hard-coded in the query metacommands. This patch
> > makes the metacommands obtain their values from the relevant #defines.
>
> Good catch! Long standing bug...
>
> > It has been tested to the extent that after changing the #define naccounts
> > downward, without the patch, after running both -i once and the benchmark
> > itself once leads to inconsistent results (select sum(abalance) from
> > pgbench_accounts does not equal sum(delta) from pgbench_history), while
> > with the patch they are equal.
>
> Looks good. If there's no objection, I will commit into CVS HEAD.

Done. Thanks Jeff!
--
Tatsuo Ishii
SRA OSS, Inc. Japan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2009-09-10 14:06:55 Re: RfD: more powerful "any" types
Previous Message Robert Haas 2009-09-10 13:58:54 Re: Ragged CSV import