X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9F602D1B9EB for ; Sun, 22 Feb 2004 19:02:55 +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 34886-10 for ; Sun, 22 Feb 2004 15:02:53 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 7E6BDD1B9BD for ; Sun, 22 Feb 2004 15:02:51 -0400 (AST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 4474990; Sun, 22 Feb 2004 11:03:58 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: "Andrew Lazarus" , Subject: Re: JOIN order, 15K, 15K, 7MM rows Date: Sun, 22 Feb 2004 11:00:40 -0800 User-Agent: KMail/1.4.3 References: <0a0c01c3f671$ceb08c80$847ba8c0@ANDYXP> In-Reply-To: <0a0c01c3f671$ceb08c80$847ba8c0@ANDYXP> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200402221100.40176.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/249 X-Sequence-Number: 5773 Andrew, > I'm running and INSERT INTO ... SELECT query with this join (one record > added per record in join), 4 hours down and all I have to show for it is > 100 recycled transaction logs. ? > > If it ever returns, I can post the Explain output. How about giving us the query and the regular EXPLAIN output right now? I've a feeling that you have an unconstrained join in the query somewhere. -- Josh Berkus Aglio Database Solutions San Francisco