pgbench not setting scale size correctly?

From: Enrico Sirola <enrico(dot)sirola(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org General" <pgsql-general(at)postgresql(dot)org>
Subject: pgbench not setting scale size correctly?
Date: 2008-03-14 09:04:01
Message-ID: 40ADA960-E0EB-4663-A31F-C85500E88106@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

Hello,
I'm trying to perform some benchmarks using pgbench. I'm using the
following rpm package:

postgresql-contrib-8.3.0-2PGDG.rhel5

for x86_64, downloaded from the pgsql yum repository for centos5/amd64.
When I init the pgbench database, the scale factor seems to work,
however when performing the benchmark I get the following output:

sudo -u postgres pgbench -c 10 -t 1000 -s 1000 pgbench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 10
number of transactions per client: 1000
number of transactions actually processed: 10000/10000
tps = 2034.588824 (including connections establishing)
tps = 2047.924715 (excluding connections establishing)

as you see, the reported scaling factor is 1, but I specified -s 1000,
which seems strange... I'm going to recompile it from the sources now.
Didn't I get anything or there is a bug somewhere?
Thanks for your help,
Enrico

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavan Deolasee 2008-03-14 09:21:12 Re: Reindex does not finish 8.2.6
Previous Message jose javier parra sanchez 2008-03-14 08:26:06 Re: postgre vs MySQL

Browse pgsql-patches by date

  From Date Subject
Next Message Pavan Deolasee 2008-03-14 09:45:23 Re: pgbench not setting scale size correctly?
Previous Message Tucker, James 2008-03-14 06:20:18 minor init script fix