Re: insert vs select into performance

On Tue, Jul 17, 2007 at 10:58:01PM +0200, Thomas Finneid wrote:
>I am not sure I understand you correctly here, are you saying that
>SELECT INTO in 8.1 disables WAL logging and uses just a single fsync at
>the end? in that case it means that I could disable WAL as well and
>achieve the same performance, does it not?

Yes. The difference is that the select into optimization just means that
if the system crashes the data you're inserting is invalid (and is
properly cleaned up), and disabling the WAL means that if the system
crashes everything is invalid (and can't be cleaned up).

Mike Stone