From: Ron <rjpeace@earthlink.net>
To: Michael Stone <mstone+postgres@mathom.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: New to PostgreSQL, performance considerations
Date: Sat, 16 Dec 2006 10:53:21 -0500
Message-ID: <E1Gvbqo-0003VC-R6@elasmtp-kukur.atl.sa.earthlink.net> (raw)
In-Reply-To: <20061216000655.GI29167@mathom.us>
References: <BCA64E3D-E764-432B-82CB-C2FC75CF3104@purefiction.net>
<E1Gv0ko-0004Ht-Jx@elasmtp-scoter.atl.sa.earthlink.net>
<CA660CCB-712C-442F-A48D-4152EF0EFF01@purefiction.net>
<E1Gv3Rc-0007M7-5X@elasmtp-galgo.atl.sa.earthlink.net>
<09D6591B-4AA9-4994-BED6-0C7C583BF933@purefiction.net>
<E1GvBfR-0005f3-11@elasmtp-scoter.atl.sa.earthlink.net>
<b42b73150612150623s761783c8l9093b2637a1f0c6c@mail.gmail.com>
<E1GvEcS-0005rM-ME@elasmtp-spurfowl.atl.sa.earthlink.net>
<b42b73150612150755s9d843f8j972f36599cf9b4dd@mail.gmail.com>
<E1GvGo0-0004Hv-Em@elasmtp-mealy.atl.sa.earthlink.net>
<20061216000655.GI29167@mathom.us>
At 07:06 PM 12/15/2006, Michael Stone wrote:
>On Fri, Dec 15, 2006 at 12:24:46PM -0500, Ron wrote:
>>ATM, the most we can say is that in a number of systems with modest
>>physical IO subsystems
>
>
>So I reran it on a 3.2GHz xeon with 6G RAM off a ramdisk; I/O ain't
>the bottleneck on that one. Results didn't show didn't show any
>signficant gains regardless of compilation options (results hovered
>around 12k tps). If people want to continue this, I will point out
>that they should make sure they're linked against the optimized
>libpq rather than an existing one elsewhere in the library path.
>Beyond that, I'm done with this thread. Maybe there are some gains
>to be found somewhere, but the testing done thus far (while limited)
>is sufficient, IMO, to demonstrate that compiler options aren't
>going to provide a blow-your-socks-off dramatic performance improvement.
AFAICT, no one has stated there would be a "blow-your-socks-off
dramatic performance improvement" for pg due to compilation
options. Just that there might be some, and there might be some that
are arch specific.
So far these experiments have shown
= multiple instances of a ~30-35% performance improvement going from
-O0 to --O3
= 1 instance of arch specific options hurting performance when
combined with -O3
= 1 instance of arch specific options helping performance on an OS
that only one person has tested (Gentoo Linux)
= that a 2.33 GHz C2D Mac laptop (under what OS?) with a typical
laptop modest physical IO subystem can do ~2100tps
= that pg has a "speed limit" on a 3.2GHz Xeon (which kind?) with 6G
RAM off a ramdisk (under what OS?) of ~12K tps
(I'd be curious to see what this limit is with better CPUs and memory
subsystems)
Note that except for the first point, all the other results are
singletons that as of yet have not been reproduced.
The most important "gain" IMO is Knowledge, and I'd say there is
still more to learn and/or verify IMHO. YMMV.
Ron Peacetree
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: rjpeace@earthlink.net, mstone+postgres@mathom.us
Subject: Re: New to PostgreSQL, performance considerations
In-Reply-To: <E1Gvbqo-0003VC-R6@elasmtp-kukur.atl.sa.earthlink.net>
* 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