Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 288582E0102 for ; Tue, 15 Jan 2008 05:33:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 51754-10 for ; Tue, 15 Jan 2008 05:33:33 -0400 (AST) Received: from p15105778.pureserver.info (p15105778.pureserver.info [217.160.133.184]) by postgresql.org (Postfix) with ESMTP id A22FC2E0251 for ; Tue, 15 Jan 2008 05:33:36 -0400 (AST) Received: by p15105778.pureserver.info (Postfix, from userid 65534) id D7DCF440D5; Tue, 15 Jan 2008 10:33:16 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by server1.proventis.net (Postfix) with ESMTP id 005FEC44294 for ; Tue, 15 Jan 2008 10:33:33 +0100 (CET) Received: from server1.proventis.net ([127.0.0.1]) by localhost (server1.proventis.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18223-09 for ; Tue, 15 Jan 2008 10:33:32 +0100 (CET) Received: from [192.168.22.130] (tmarkus.proventis.net [192.168.22.130]) by server1.proventis.net (Postfix) with ESMTP id 96ADBC44292 for ; Tue, 15 Jan 2008 10:33:32 +0100 (CET) Message-ID: <478C7DEC.1020806@proventis.net> Date: Tue, 15 Jan 2008 10:33:32 +0100 From: Thomas Markus Organization: proventis GmbH User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: update performance 8.1.4 Content-Type: multipart/mixed; boundary="------------080205040707060600040606" X-Virus-Scanned: by amavisd-new at proventis.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/152 X-Sequence-Number: 27926 This is a multi-part message in MIME format. --------------080205040707060600040606 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 8bit Hi, How can I speed up updates? i try an update tablename set datecol=null ~ 2.3 mio rows After 6 hours, this was still not finished. selects and inserts are ok. System is a dual xeon, 8gb ram, debian 64bit, pg 8.1.4 thanks thomas -- Thomas Markus Tel: +49 30 29 36 399 - 22 Fax: +49 30 29 36 399 - 50 Mail: t.markus@proventis.net Web: http://www.proventis.net Web: http://www.blue-ant.de proventis GmbH Zimmerstraße 79-80 10117 Berlin Geschäftsführer: Norman Frischmuth Sitz: Berlin Handelsregister: AG Berlin-Charlottenburg, HR 82917 We support your project business! --------------080205040707060600040606 Content-Type: text/x-vcard; charset=utf-8; name="t_markus.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="t_markus.vcf" begin:vcard fn:Thomas Markus n:Markus;Thomas org:proventis GmbH adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany email;internet:t.markus@proventis.net tel;work:+49 30 29 36 399 22 x-mozilla-html:FALSE url:http://www.proventis.net version:2.1 end:vcard --------------080205040707060600040606--