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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
