From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jon Brisbin <jon.brisbin@npcinternational.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: 8.1beta3 performance
Date: Tue, 01 Nov 2005 12:24:43 -0500
Message-ID: <26529.1130865883@sss.pgh.pa.us> (raw)
In-Reply-To: <20051101085037.1b12b077@fc63r41.npci.com>
References: <dk68ku$2lqa$1@news.hub.org>
<20051101085037.1b12b077@fc63r41.npci.com>
Jon Brisbin <jon.brisbin@npcinternational.com> writes:
> I have a stock FreeBSD 5.4 box that I put 8.1 on last night. I ran
> pgbench against it and my tps dropped from ~300tps in 8.0.3 to 20tps
> in 8.1. That's right. 20. No changes in any system configuration.
You sure about that last? These numbers are kind of consistent with the
idea that fsync is off in the 8.0 database and on in the 8.1 database.
Using the same test case you mention (pgbench -s 10, -c 25 -t 1000),
I find that 8.1 is a bit faster than 8.0, eg
8.1 fsync off:
tps = 89.831186 (including connections establishing)
tps = 89.865065 (excluding connections establishing)
8.1 fsync on:
tps = 74.865078 (including connections establishing)
tps = 74.889066 (excluding connections establishing)
8.0 fsync off:
tps = 80.271338 (including connections establishing)
tps = 80.302054 (excluding connections establishing)
8.0 fsync on:
tps = 67.405708 (including connections establishing)
tps = 67.426546 (excluding connections establishing)
(All database parameters are defaults except fsync.)
These numbers are with assert-enabled builds, on a cheap PC whose drive
lies about write-complete, so they're not very representative of the
real world I suppose. But I'm sure not seeing any 10x degradation.
regards, tom lane
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, jon.brisbin@npcinternational.com
Subject: Re: 8.1beta3 performance
In-Reply-To: <26529.1130865883@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