X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9ED2DD1BAE9 for ; Sat, 24 Apr 2004 00:02:21 -0300 (ADT) 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 91433-03 for ; Sat, 24 Apr 2004 00:02:19 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 523B3D1BAD5 for ; Sat, 24 Apr 2004 00:02:19 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3O32HAw006899; Fri, 23 Apr 2004 23:02:17 -0400 (EDT) To: Tyler Ward Cc: pgsql-admin@postgresql.org, Tyler Ward Subject: Re: Problem with inserts from subselects In-reply-to: <40892875.70409@columbia.edu> References: <40892875.70409@columbia.edu> Comments: In-reply-to Tyler Ward message dated "Fri, 23 Apr 2004 10:30:13 -0400" Date: Fri, 23 Apr 2004 23:02:16 -0400 Message-ID: <6898.1082775736@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=MAILTO_TO_SPAM_ADDR X-Spam-Level: * X-Archive-Number: 200404/303 X-Sequence-Number: 13276 Tyler Ward writes: > I'm using postgres 7.3.x (the default installed on Fedora Core 1) and > I'm running into a serious > bug in the insert performance. Could we see EXPLAIN ANALYZE output from all three cases? I'd have expected "INSERT ... SELECT foo" to generate the same plan as "SELECT foo", but it sounds like you're getting something different. regards, tom lane