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

From Adriaan van Os
Subject Re: insert vs select into performance
Date
Msg-id 469E69E8.3080204@microbizz.nl
Whole thread Raw
In response to Re: insert vs select into performance  (Michael Stone <mstone+postgres@mathom.us>)
Responses Re: insert vs select into performance  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-performance
Michael Stone wrote:
> 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).

So, how does one (temporarily) disable WAL logging ? Or, for example, disable WAL logging for a
temporary table ?

Regards,

Adriaan van Os

pgsql-performance by date:

Previous
From: Thomas Finneid
Date:
Subject: Re: improvement suggestions for performance design
Next
From: Heikki Linnakangas
Date:
Subject: Re: insert vs select into performance