Josh Berkus <[email protected]> writes:
>> THe only fundamental disadvantage that COPY labors under is having to
>> write WAL records. It might be interesting to do something similar to
>> the recent hacks for CREATE TABLE AS, so that a COPY into a table just
>> created in the current transaction would skip writing WAL and instead
>> fsync the table at the end.
> Yes, I thought we discussed doing this for empty tables -- it would be, per
> our tests, a +10% to +30% boost to COPY.
> But there was some problem the patch?
I have seen no such patch AFAIR.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
