Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6F9D12E00EF for ; Tue, 15 Jan 2008 11:21:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 31474-03 for ; Tue, 15 Jan 2008 11:21:46 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.178]) by postgresql.org (Postfix) with ESMTP id 1542E2E0033 for ; Tue, 15 Jan 2008 11:21:54 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so4692077waf.5 for ; Tue, 15 Jan 2008 07:21:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=1cVDmXNcLnG7BSa5ILaNQIUkJZmaO0T7iGxqlREuiOI=; b=DAvZQoKb59srrSJHE36f0pyQva21nlJtkd/uboC/04YWm3REdIwTlCDSuC8opweMOg2WlJSKkEDT7A7MyEZSiliBYKkSnWw7ewgywAH+/tP1YheXrAv+NJkZqw4YaKv0j0swDGj9rwJE3qdaid6gF2ieCWpZo7pvaYzaESTJtCE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=sdb4pjBYp7kcJySjRGzHpMu1AHkvK9LM3sghoYY/SsWEYCp3VvNfvz8YCio9UQJ72ljX6yHAvH+eA9vGPvQXbLgfvquVXAkMKTSGYr/RmlR9eF2r8pF2s/Ss1HXsinXKsnRHSBipLJJIX+Cah+JzbfRuhXrNVRgwgfkYCb2M2uQ= Received: by 10.114.89.1 with SMTP id m1mr4436181wab.77.1200410512781; Tue, 15 Jan 2008 07:21:52 -0800 (PST) Received: by 10.114.131.4 with HTTP; Tue, 15 Jan 2008 07:21:52 -0800 (PST) Message-ID: Date: Tue, 15 Jan 2008 09:21:52 -0600 From: "Scott Marlowe" To: "Thomas Markus" Subject: Re: update performance 8.1.4 Cc: pgsql-admin@postgresql.org In-Reply-To: <478C7DEC.1020806@proventis.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <478C7DEC.1020806@proventis.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/155 X-Sequence-Number: 27929 2008/1/15 Thomas Markus : > Hi, > > How can I speed up updates? > i try an > update tablename set datecol=null > ~ 2.3 mio rows Got any foreign keys against that table? If so, they need to be indexed on the other end. What's the schema of that table and any related tables?