| 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: | Whole Thread | Raw Message | 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 |