Josh Berkus <josh@agliodbs.com> 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