Re: insert vs select into performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: insert vs select into performance
Date
Msg-id 5666.1184704280@sss.pgh.pa.us
Whole thread Raw
In response to Re: insert vs select into performance  (Michael Glaesemann <grzm@seespotcode.net>)
Responses Re: insert vs select into performance
List pgsql-performance
Michael Glaesemann <grzm@seespotcode.net> 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

pgsql-performance by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: insert vs select into performance
Next
From: Thomas Finneid
Date:
Subject: Re: insert vs select into performance