Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 2BB9E9FB823 for ; Tue, 17 Jul 2007 17:31:25 -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 18554-05 for ; Tue, 17 Jul 2007 17:31:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 902389FB512 for ; Tue, 17 Jul 2007 17:31:21 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l6HKVKEU005667; Tue, 17 Jul 2007 16:31:20 -0400 (EDT) To: Michael Glaesemann cc: Thomas Finneid , pgsql-performance@postgresql.org Subject: Re: insert vs select into performance In-reply-to: <0D6011B2-D09F-45E8-A5D7-5F84ADD1DC2B@seespotcode.net> References: <469D1AD3.9030004@ifi.uio.no> <0D6011B2-D09F-45E8-A5D7-5F84ADD1DC2B@seespotcode.net> Comments: In-reply-to Michael Glaesemann message dated "Tue, 17 Jul 2007 14:54:55 -0500" Date: Tue, 17 Jul 2007 16:31:20 -0400 Message-ID: <5666.1184704280@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/193 X-Sequence-Number: 25877 Michael Glaesemann writes: > It would be helpful if you included the actual queries you're using, > as there are a number of variables: Not to mention which PG version he's testing. Since (I think) 8.1, SELECT INTO knows that it can substitute one fsync for WAL-logging the individual row inserts, since if there's a crash the new table will disappear anyway. regards, tom lane