X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 424F5D7337 for ; Mon, 29 Aug 2005 14:27:32 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41970-06 for ; Mon, 29 Aug 2005 17:27:29 +0000 (GMT) Received: from rwcrmhc12.comcast.net (rwcrmhc13.comcast.net [216.148.227.118]) by svr1.postgresql.org (Postfix) with ESMTP id C3218D6FEB for ; Mon, 29 Aug 2005 14:27:27 -0300 (ADT) Received: from jefftrout.com ([24.147.120.205]) by comcast.net (rwcrmhc13) with SMTP id <2005082917272601500a0cgue>; Mon, 29 Aug 2005 17:27:27 +0000 Received: (qmail 17864 invoked from network); 29 Aug 2005 17:28:24 -0000 Received: from c-24-147-120-205.hsd1.ma.comcast.net (HELO ?192.168.0.106?) (24.147.120.205) by 192.168.0.109 with SMTP; 29 Aug 2005 17:28:24 -0000 In-Reply-To: <26476.1125259249@sss.pgh.pa.us> References: <26476.1125259249@sss.pgh.pa.us> Mime-Version: 1.0 (Apple Message framework v733) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <486EB962-5B80-49B4-AF01-0C2DD77CC9EF@torgo.978.org> Cc: postgres performance Content-Transfer-Encoding: 7bit From: Jeff Trout Subject: Re: OSX & Performance Date: Mon, 29 Aug 2005 13:27:25 -0400 To: Tom Lane X-Mailer: Apple Mail (2.733) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 required=5 tests=[AWL=-0.000, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200508/494 X-Sequence-Number: 14241 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 http://www.jefftrout.com/ http://www.stuarthamm.net/