Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id E8E87632771
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 14 Jan 2010 17:42:35 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 81048-04
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 14 Jan 2010 21:42:20 +0000 (UTC)
X-Greylist: delayed 00:16:06.168675 by SQLgrey-1.7.6
Received: from mail-qy0-f190.google.com (mail-qy0-f190.google.com
	[209.85.221.190])
	by mail.postgresql.org (Postfix) with ESMTP id C51E06323AF
	for <pgsql-performance@postgresql.org>;
	Thu, 14 Jan 2010 17:42:23 -0400 (AST)
Received: by qyk28 with SMTP id 28so12990856qyk.28
	for <pgsql-performance@postgresql.org>;
	Thu, 14 Jan 2010 13:42:22 -0800 (PST)
Received: by 10.224.7.130 with SMTP id d2mr1328579qad.217.1263503949365;
	Thu, 14 Jan 2010 13:19:09 -0800 (PST)
Received: from ?192.168.0.78? (rrcs-64-183-7-130.west.biz.rr.com
	[64.183.7.130])
	by mx.google.com with ESMTPS id 9sm357773ywf.35.2010.01.14.13.19.07
	(version=SSLv3 cipher=RC4-MD5); Thu, 14 Jan 2010 13:19:08 -0800 (PST)
Message-ID: <4B4F8A49.7010906@emolecules.com>
Date: Thu, 14 Jan 2010 13:19:05 -0800
From: Craig James <craig_james@emolecules.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: Carlo Stonebanks <stonec.register@sympatico.ca>
CC: pgsql-performance@postgresql.org
Subject: Re: Massive table (500M rows) update nightmare
References: <hi41os$eiv$1@news.hub.org>
	<b1b9fac61001071305vf182f3ajff6827f92c943c68@mail.gmail.com>
	<hi5kpr$184c$1@news.hub.org>
	<dcc563d11001071740q572cdae2re410788fe790dbf6@mail.gmail.com>
	<hinqok$1ono$1@news.hub.org>
In-Reply-To: <hinqok$1ono$1@news.hub.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.169 tagged_above=-10 required=5 tests=AWL=-0.984,
	BAYES_40=-0.185
X-Spam-Level: 
X-Archive-Number: 201001/315
X-Sequence-Number: 37195

Carlo Stonebanks wrote:
> Guys, I want to thank you for all of the advice - my client has just 
> made a surprise announcement that he would like to set start from 
> scratch with a new server, so I am afraid that all of this great advice 
> has to be seen in the context of whatever decision is made on that. I am 
> out there, hat-in-hand, looking for advice under the PERFORM post: "New 
> server to improve performance on our large and  busy DB - advice?"

You might start this as a new topic with a relevant title, and reiterate your database requirements.  Otherwise it will get submerged as just a footnote to your original question.  It's really nice to be able to quickly find the new-equipment discussions.

Craig