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
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 |
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 |