Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id F0A809F9EED for ; Mon, 11 Dec 2006 16:07:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 41046-01 for ; Mon, 11 Dec 2006 16:07:25 -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.233]) by postgresql.org (Postfix) with ESMTP id ECE3C9F9386 for ; Mon, 11 Dec 2006 16:07:27 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so831881nzh for ; Mon, 11 Dec 2006 12:07:27 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=kUdtSxwAKLd+nUwRmPPVMt1WmiM9VqdlEg6LEkCmCsU4CHRp9hHIq4oqgaGuBDcZ9hQNZxAu/evki62nvXSMlYzR+zUkuz+8vQ5vfnzoXof+vnEBlxkS/UcLV3i/HIqduiRAleNKyTIZpz3dT3lWPtsalVtmoKr2T4n57aZpo5M= Received: by 10.65.210.18 with SMTP id m18mr4694958qbq.1165867646626; Mon, 11 Dec 2006 12:07:26 -0800 (PST) Received: by 10.65.215.20 with HTTP; Mon, 11 Dec 2006 12:07:26 -0800 (PST) Message-ID: <8a0c7af10612111207u9f3763dg4eb381b37bd98304@mail.gmail.com> Date: Mon, 11 Dec 2006 18:07:26 -0200 From: "Daniel van Ham Colchete" To: pgsql-performance@postgresql.org Subject: Re: New to PostgreSQL, performance considerations In-Reply-To: <20061211140256.GA25975@uio.no> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <8a0c7af10612101141n2c7727c3r2f92345753960808@mail.gmail.com> <430d92a20612101336r3de8862coe618277fccb4006a@mail.gmail.com> <8a0c7af10612101702i49b5a533v4a2300d90d9dae6b@mail.gmail.com> <20061211021847.GE16692@mathom.us> <8a0c7af10612110305u305124b2v3d63491b5f57a86b@mail.gmail.com> <20061211121547.GF16692@mathom.us> <8a0c7af10612110517v26025645i3d191b9e7e5ab742@mail.gmail.com> <20061211140256.GA25975@uio.no> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/258 X-Sequence-Number: 22314 On 12/11/06, Steinar H. Gunderson wrote: > On Mon, Dec 11, 2006 at 11:17:06AM -0200, Daniel van Ham Colchete wrote: > > I just remebered one case with MySQL. When I changed the distro from > > Conectiva 10 (rpm-based ended brazilian distro) to Gentoo, a MySQL > > operation that usually took 2 minutes to run, ended in 47 seconds. > > How do you know that this improvement had _anything_ to do with the use of > different optimization flags? Were even the MySQL versions or configuration > the same? > > > This is absolutely vage. > > Indeed it is. Finally we agreed on something. > > > I don't have how to prove it to you. > > No, but you should stop making this sort of "absolutely essential" claims if > you can't. > > > And I can't mesure how each factor helped: compiling glibc and Mysql with > > good cflags, rebuilding my database in a ordered way, never kernel, etc.. > > Exactly. So why are you attributing it to the first factor only? And why do > you think this would carry over to PostgreSQL? > > Remember, anecdotal evidence isn't. But that's exactly what I said. I'm not attributing this case to the optimization factor. As I said there are a lot of factors involved. The MySQL version change of a minor upgrade (from 4.1.15 to 4.1.21). Steinar, I say I'll do the benchmark and it will be the end of the story. > > /* Steinar */