Skip site navigation (1) Skip section navigation (2)

Re: insert vs select into performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: Thomas Finneid <tfinneid(at)student(dot)matnat(dot)uio(dot)no>, pgsql-performance(at)postgresql(dot)org
Subject: Re: insert vs select into performance
Date: 2007-07-17 20:31:20
Message-ID: 5666.1184704280@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Michael Glaesemann <grzm(at)seespotcode(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Thomas FinneidDate: 2007-07-17 20:50:22
Subject: Re: insert vs select into performance
Previous:From: Michael GlaesemannDate: 2007-07-17 19:54:55
Subject: Re: insert vs select into performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group