Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8CE8F9F9398 for ; Tue, 12 Dec 2006 11:57:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 45278-02 for ; Tue, 12 Dec 2006 11:57:23 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0102.google.com (nz-out-0506.google.com [64.233.162.228]) by postgresql.org (Postfix) with ESMTP id 61D9D9F9357 for ; Tue, 12 Dec 2006 11:57:23 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so980917nzh for ; Tue, 12 Dec 2006 07:57:22 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=NAG3Ra7CTnesAs6AKAMgGTa1jaQ3qzqUT2POuGjfCcwfvpex9iGoKF9w7OS7NlBdweZWUkf3tE2JLVshFlpT74oWZoa6aqycmw5nXd5dFopw4RaFtmiPULiq4jCV1bmNaI2pGx/0Ltvi0YX5xNzru/eiM6tIG+O41WET0yy3yRs= Received: by 10.65.59.20 with SMTP id m20mr7309917qbk.1165939041243; Tue, 12 Dec 2006 07:57:21 -0800 (PST) Received: by 10.65.215.20 with HTTP; Tue, 12 Dec 2006 07:57:20 -0800 (PST) Message-ID: <8a0c7af10612120757t3e2add5ckb512af8f794a2235@mail.gmail.com> Date: Tue, 12 Dec 2006 13:57:20 -0200 From: "Daniel van Ham Colchete" To: "Florian Weimer" Subject: Re: New to PostgreSQL, performance considerations Cc: "Cosimo Streppone" , "Postgresql Performance list" In-Reply-To: <82psapuos8.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <457EA39E.1020207@streppone.it> <82psapuos8.fsf@mid.bfk.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/296 X-Sequence-Number: 22352 On 12/12/06, Florian Weimer wrote: > * Cosimo Streppone: > > > "-O0" ~ 957 tps > > "-O1 -mcpu=pentium4 -mtune=pentium4" ~ 1186 tps > > "-O2 -mcpu=pentium4 -mtune=pentium4" ~ 1229 tps > > "-O3 -mcpu=pentium4 -mtune=pentium4" ~ 1257 tps > > "-O6 -mcpu=pentium4 -mtune=pentium4" ~ 1254 tps > > -mcpu and -mtune are synonymous. You really should -march here (but > the result is non-generic code). Keep in mind that GCC does not > contain an instruction scheduler for the Pentium 4s. I also believe > that the GCC switches are not fine-grained enough to cover the various > Pentium 4 variants. For instance, some chips don't like the CMOV > instruction at all, but others can process it with decent speed. You can use -march=pentium4, -march=prescott and -march=nocona to the different Pentium4 processors. But you have to use -march (and not -mcpu or -mtune) because without it you are still using only i386 instructions. Daniel