Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6A4C69F9FDD for ; Mon, 29 Oct 2007 07:45:38 -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 62297-01-2 for ; Mon, 29 Oct 2007 07:45:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.174]) by postgresql.org (Postfix) with ESMTP id 34BD99F9E2B for ; Mon, 29 Oct 2007 07:45:34 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu8) with ESMTP (Nemesis) id 0ML31I-1ImS7f20fk-0003mK; Mon, 29 Oct 2007 11:45:33 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1ImS7d-0006FI-00 for pgsql-sql@postgresql.org; Mon, 29 Oct 2007 11:45:29 +0100 Date: Mon, 29 Oct 2007 11:45:29 +0100 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: update from select Message-ID: <20071029104529.GB16653@a-kretschmer.de> References: <0d5e01c81a0c$b0f67250$1601a8c0@kbsc1> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <0d5e01c81a0c$b0f67250$1601a8c0@kbsc1> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX18kPrE9wEdnH/NPdr7Yr26avCbnMueGtPA2qdl MuSfY/ju/xbFo1oBm9FQoWupJF3IWBXeXUQdMeCRE3tQV1TyCC LFwMgeNkrRolbzYtJLy1if4iaLfidep X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/143 X-Sequence-Number: 29515 am Mon, dem 29.10.2007, um 10:18:38 +0100 mailte dev@kbsolutions.ch folgendes: > > WHERE table1.column1 = temp_table.column1; table1.column1 and temp_table.column1 have the same type? > > > > The select by it?s own takes around 1 second. The Update is around 120?000 > rows. I got an index on column1. The whole query needs around 16 minutes. Show us the EXPLAIN ANALYSE - result. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net