pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpgbench output
3+ messages / 3 participants
[nested] [flat]
* pgbench output
@ 2006-02-02 07:09 Pradeep Parmar <pradeep.dba@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Pradeep Parmar @ 2006-02-02 07:09 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgbench output
@ 2006-02-07 05:06 Jim C. Nasby <jnasby@pervasive.com>
parent: Pradeep Parmar <pradeep.dba@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jim C. Nasby @ 2006-02-07 05:06 UTC (permalink / raw)
To: Pradeep Parmar <pradeep.dba@gmail.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgbench output
@ 2006-02-10 15:41 Gourish Singbal <gourish@gmail.com>
parent: Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 0 replies; 3+ messages in thread
From: Gourish Singbal @ 2006-02-10 15:41 UTC (permalink / raw)
To: Jim C. Nasby <jnasby@pervasive.com>; +Cc: Pradeep Parmar <pradeep.dba@gmail.com>; pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-02-10 15:41 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-02 07:09 pgbench output Pradeep Parmar <pradeep.dba@gmail.com>
2006-02-07 05:06 ` Jim C. Nasby <jnasby@pervasive.com>
2006-02-10 15:41 ` Gourish Singbal <gourish@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox