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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Thomas Finneid 2007-07-17 20:50:22 Re: insert vs select into performance
Previous Message Michael Glaesemann 2007-07-17 19:54:55 Re: insert vs select into performance