From: Jeff Trout <threshar@torgo.978.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: postgres performance <pgsql-performance@postgresql.org>
Subject: Re: OSX & Performance
Date: Mon, 29 Aug 2005 13:27:25 -0400
Message-ID: <486EB962-5B80-49B4-AF01-0C2DD77CC9EF@torgo.978.org> (raw)
In-Reply-To: <26476.1125259249@sss.pgh.pa.us>
References: <C5CA67B2-E8DC-414D-B298-A9292323F26E@torgo.978.org>
<26476.1125259249@sss.pgh.pa.us>
On Aug 28, 2005, at 4:00 PM, Tom Lane wrote:
>
> Hmm, can you provide a test case for other people to poke at?
>
I'l try to put one together as small as I can make it.
The table in question is roughly 22M rows. There are about 8k rows
per timestamp (day granularity).
> I see -O2 when building PG (CVS tip) on a fully up-to-date 10.4.2
> machine. Maybe something odd in your environment, like a preset
> CFLAGS setting?
>
8.0.3 doesn't have any optimization flags
8.1beta1 doesn't have any optimization
ie: gcc -no-cpp-precomp -Wall -Wmissing-prototypes -Wpointer-arith -
Wdeclaration-after-statement -Wold-style-definition -Wendif-labels -
fno-strict-aliasing -I../../src/port -I../../src/include -c
thread.c -o thread_srv.o
I'm on 10.4.2, xcode 2.1
Using built-in specs.
Target: powerpc-apple-darwin8
Configured with: /private/var/tmp/gcc/gcc-5026.obj~19/src/configure --
disable-checking --prefix=/usr --mandir=/share/man --enable-
languages=c,objc,c++,obj-c++ --program-transform-name=/^[cg][^+.-]*$/
s/$/-4.0/ --with-gxx-include-dir=/include/gcc/darwin/4.0/c++ --
build=powerpc-apple-darwin8 --host=powerpc-apple-darwin8 --
target=powerpc-apple-darwin8
Thread model: posix
gcc version 4.0.0 (Apple Computer, Inc. build 5026)
The snapshot on ftp.psotgresql.org (dated 8/29) also runs with no
optimization.
No cflags are set.
need to see anything from config.log?
--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/http://www.stuarthamm.net/
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: threshar@torgo.978.org, tgl@sss.pgh.pa.us
Subject: Re: OSX & Performance
In-Reply-To: <486EB962-5B80-49B4-AF01-0C2DD77CC9EF@torgo.978.org>
* 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