Re: 8.4 open item: copy performance regression? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.4 open item: copy performance regression?
Date
Msg-id 18196.1245683664@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.4 open item: copy performance regression?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: 8.4 open item: copy performance regression?  (Stephen Frost <sfrost@snowman.net>)
Re: 8.4 open item: copy performance regression?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Stephen Frost <sfrost@snowman.net> writes:
> * Tom Lane (tgl@sss.pgh.pa.us) wrote:
>> The more useful case for data load is "create or truncate it in the
>> same transaction", of course.

> Unfortunately, WAL bypass also requires not being in archive mode with
> no way to turn that off w/o a server restart, aiui.

Well, if you're trying to archive then you certainly wouldn't want WAL
off, so I'm failing to see where this thread is going ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: 8.4 open item: copy performance regression?
Next
From: Stephen Frost
Date:
Subject: Re: 8.4 open item: copy performance regression?