> Gavin Sherry
> Just thinking of optimisations, I wonder if it would be possible to bypass
> WAL (like we do for ALTER TABLE ... SET TABLESPACE) if archiving is
> disabled, and fsync the newly created relfilenode  after the data is
inserted.
>

Yes please. This is good for Data Warehousing ELT-style operations.
(Extract, Load, Transform).

If I could go further, I'd like to add this as an option on the command if
possible, rather than a presumption that all such statements should not be
logged.

Thanks,

Best Regards, Simon Riggs



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to