Re: OSX & Performance

From: Jeff Trout
Subject: Re: OSX & Performance
Date: ,
(view: Whole thread, Raw)
In response to: Re: OSX & Performance  (Tom Lane)
Responses: Re: OSX & Performance  (Tom Lane)
List: pgsql-performance

Tree view

OSX & Performance  (Jeff Trout, )
 Re: OSX & Performance  (Tom Lane, )
  Re: OSX & Performance  (Jeff Trout, )
   Re: OSX & Performance  (Tom Lane, )
    Re: OSX & Performance  (Jeff Trout, )

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 --
Thread model: posix
gcc version 4.0.0 (Apple Computer, Inc. build 5026)

The snapshot on (dated 8/29) also runs with no

No cflags are set.

need to see anything from config.log?

Jeff Trout <>

pgsql-performance by date:

From: asif ali
Subject: Re: Weird performance drop after VACUUM
From: Christopher Kings-Lynne
Subject: Re: shared buffers