Обсуждение: pgbench output

Поиск
Список
Период
Сортировка

pgbench output

От
Pradeep Parmar
Дата:
Hi,

I'm fairly new to PostgreSQL. I was trying pgbench , but could not understand the output . Can anyone help me out to understand the output of pgbench


----Pradeep

Re: pgbench output

От
"Jim C. Nasby"
Дата:
Well, it tells you how many transactions per second it was able to do.
Do you have specific questions?

On Thu, Feb 02, 2006 at 12:39:59PM +0530, Pradeep Parmar wrote:
> Hi,
>
> I'm fairly new to PostgreSQL. I was trying pgbench , but could not
> understand the output . Can anyone help me out to understand the output of
> pgbench
>
>
> ----Pradeep

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

Re: pgbench output

От
Gourish Singbal
Дата:
 
Hi All,
 
Here are some of the results i got after performing pgbench marking between postgresql 7.4.5 and postgresql 8.1.2. having parameters with same values in the postgresql.conf file.
 
postgres@machine:/newdisk/postgres/data> /usr/local/pgsql7.4.5/bin/pgbench -c 10 -t 10000 regression
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
tps = 80.642615 (including connections establishing)
tps = 80.650638 (excluding connections establishing)

postgres@machine:/newdisk/postgres/data> /usr/local/pgsql/bin/pgbench -c 10 -t 10000 regression
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
tps = 124.134926 (including connections establishing)
tps = 124.148749 (excluding connections establishing)

Conclusion : So please correct me if i am wrong ... this result set shows that the postgresql version  8.1.2 has perform better than 7.4.5 in the bench marking process since 8.1.2 was able to complete more transcations per second successfully .


On 2/7/06, Jim C. Nasby <jnasby@pervasive.com> wrote:

Well, it tells you how many transactions per second it was able to do.
Do you have specific questions?

On Thu, Feb 02, 2006 at 12:39:59PM +0530, Pradeep Parmar wrote:
> Hi,
>
> I'm fairly new to PostgreSQL. I was trying pgbench , but could not
> understand the output . Can anyone help me out to understand the output of
> pgbench
>
>
> ----Pradeep

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software       http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster



--
Best,
Gourish Singbal