X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8AEAAD1B4BD for ; Thu, 11 Dec 2003 06:04:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 76711-09 for ; Thu, 11 Dec 2003 02:04:02 -0400 (AST) Received: from linda-2.paradise.net.nz (bm-2a.paradise.net.nz [202.0.58.21]) by svr1.postgresql.org (Postfix) with ESMTP id 5D4BFD1B481 for ; Thu, 11 Dec 2003 02:04:01 -0400 (AST) Received: from smtp-3.paradise.net.nz (smtp-3a.paradise.net.nz [202.0.32.196]) by linda-2.paradise.net.nz (Paradise.net.nz) with ESMTP id <0HPP005JQVID8M@linda-2.paradise.net.nz> for pgsql-performance@postgresql.org; Thu, 11 Dec 2003 19:03:50 +1300 (NZDT) Received: from paradise.net.nz (218-101-14-73.paradise.net.nz [218.101.14.73]) by smtp-3.paradise.net.nz (Postfix) with ESMTP id B082FADF83; Thu, 11 Dec 2003 19:03:49 +1300 (NZDT) Date: Thu, 11 Dec 2003 19:04:15 +1300 From: Mark Kirkwood Subject: Re: Solaris Performance (Again) In-reply-to: <20031210085323.749a549f.threshar@torgo.978.org> To: Jeff Cc: pgsql-performance@postgresql.org Message-id: <3FD808DF.9080504@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20031008 References: <3FD6B596.8090803@paradise.net.nz> <20031210085323.749a549f.threshar@torgo.978.org> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/174 X-Sequence-Number: 5034 Good point - It is Pg 7.4beta1 , compiled with CFLAGS += -O2 -funroll-loops -fexpensive-optimizations Jeff wrote: > >What version of PG? > >If it is before 7.4 PG compiles with _NO_ optimization by default and >was a huge part of the slowness of PG on solaris. > > > >