X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CA514D1B454 for ; Tue, 9 Dec 2003 08:32:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 83357-10 for ; Tue, 9 Dec 2003 04:32:26 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id BA86BD1B438 for ; Tue, 9 Dec 2003 04:32:24 -0400 (AST) Received: from tokyo.samurai.com (d226-89-59.home.cgocable.net [24.226.89.59]) by bob.samurai.com (Postfix) with ESMTP id 10DDD1F93; Tue, 9 Dec 2003 03:32:25 -0500 (EST) To: stephen farrell Cc: pgsql-performance@postgresql.org Subject: Re: Problem with insert into select... From: Neil Conway In-Reply-To: <3FBD72D5.1040202@almaden.ibm.com> (stephen farrell's message of "Thu, 20 Nov 2003 18:05:09 -0800") References: <3FBD2D8B.8020509@almaden.ibm.com> <7439.1069369120@sss.pgh.pa.us> <3FBD72D5.1040202@almaden.ibm.com> Date: Tue, 09 Dec 2003 03:32:24 -0500 Message-ID: <87smjuqtlz.fsf@mailbox.samurai.com> User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/157 X-Sequence-Number: 5017 stephen farrell writes: > With the indexes created it worked. It took about 4 hours, but it > inserted all of the records. Has this been satisfactorily resolved? If not, can you post an EXPLAIN ANALYZE for the failing query, as Tom asked earlier? -Neil