Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 537A19FB34E for ; Mon, 28 May 2007 00:52:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 57521-08 for ; Mon, 28 May 2007 00:52:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.227]) by postgresql.org (Postfix) with ESMTP id 61BBD9FB33B for ; Mon, 28 May 2007 00:52:05 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id m22so233620nzf for ; Sun, 27 May 2007 20:52:04 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=BSYdnEOxe0pFJmniBjkYA+GsnU3ckHOaRpxEi5pkoWGxGUNce6ZOXeW/sZVFwGXaydyN18BacoiyfqvCYI26KbSwRDDsR+F9pt3gnTESODCVManAsLE0SDuCc73lvQ1Ox85gLZYeVqMH7txZClpT01y1aC/6FNy7Q1HNuUvrm/4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=SXTqIPiNWXXWoNe8V4P+2nV8KSOItvpDorpmewQTRUrGZWDcgZIaESkFecTG4BKYF0qkTT+pjgnOzC+/c2T4907d95GbRz1P7BRKd9wYB0I7wQfkup0gZ2WgK6vCOSCoASaqxLqaBvfpJvVFbvw/YTUWJE4zRM6TvyhMYx5dKYI= Received: by 10.114.170.1 with SMTP id s1mr2711522wae.1180324324287; Sun, 27 May 2007 20:52:04 -0700 (PDT) Received: from ?10.1.1.11? ( [203.217.18.65]) by mx.google.com with ESMTP id q18sm8800251pog.2007.05.27.20.52.01; Sun, 27 May 2007 20:52:02 -0700 (PDT) Message-ID: <465A522C.4030701@gmail.com> Date: Mon, 28 May 2007 13:53:16 +1000 From: Chris User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: PFC CC: pgsql-performance@postgresql.org Subject: Re: Postgres Benchmark Results References: <87hcq5l1c7.fsf@oxford.xeocode.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/568 X-Sequence-Number: 24958 > I am re-running it with other tuning, notably cost-based vacuum > delay and less frequent checkpoints, and it is a *lot* smoother. > These take a full night to run, so I'll post more results when I > have usefull stuff to show. > This has proven to be a very interesting trip to benchmarkland... [ rather late in my reply but I had to ] Are you tuning mysql in a similar fashion ? -- Postgresql & php tutorials http://www.designmagick.com/