pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: kondo_yo@itg.hitachi.co.jp
Cc: pgsql-performance@postgresql.org
Subject: Re: Question of performance of version 8
Date: Mon, 20 Dec 2004 22:54:20 -0500
Message-ID: <2255.1103601260@sss.pgh.pa.us> (raw)
In-Reply-To: <XNM1$2$0$3$$7$7$8$A$0001492U41c77f63@itg.hitachi.co.jp>
References: <XNM1$2$0$3$$7$7$8$A$0001492U41c77f63@itg.hitachi.co.jp>
kondo_yo@itg.hitachi.co.jp writes:
> I tried performance test of version 8.0.0 beta4 by osdl-dbt-1.
> The result is that throughput of version 8 fell to about 70 percent
> compared with V7.4.6.
beta4 is a little bit back ...
I don't have dbt1 at hand, but I tried pg_bench on PG 7.4.6 against 8.0rc2
just now. For the test case
pgbench -i -s 10 bench
pgbench -c 10 -t 10000 bench
on 7.4.6 I get:
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 = 65.714249 (including connections establishing)
tps = 65.716363 (excluding connections establishing)
on 8.0rc2 I get:
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 = 107.379742 (including connections establishing)
tps = 107.385301 (excluding connections establishing)
This is on a Fedora Core 3 machine, generic three-year-old PC with cheap
junk IDE drive that lies about write completion (but I'm running fsync
off so that hardly matters ;-)). And I didn't change any of the default
postgresql.conf settings, just started the postmaster with -F in both
cases. So I wouldn't claim that it's very representative of real-world
performance on real-world server hardware. But I'm not seeing a serious
falloff from 7.4 to 8.0 here --- more the other way 'round.
Please try dbt1 with 8.0rc2, and let us know if you still see a problem.
regards, tom lane
view thread (3+ messages) latest in thread
Message-ID: <2255.1103601260@sss.pgh.pa.us> Permalink: ../2255.1103601260@sss.pgh.pa.us/ Also on: postgresql.org/message-id/2255.1103601260@sss.pgh.pa.us ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-performance@postgresql.org Cc: tgl@sss.pgh.pa.us, kondo_yo@itg.hitachi.co.jp Subject: Re: Question of performance of version 8 In-Reply-To: <2255.1103601260@sss.pgh.pa.us> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
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