Re: code question: storing INTO relation - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: code question: storing INTO relation
Date
Msg-id 003401c4b7b8$8e1fca10$06e887d9@Nightingale
Whole thread Raw
In response to code question: storing INTO relation  (Neil Conway <neilc@samurai.com>)
Responses Re: code question: storing INTO relation
List pgsql-hackers
> 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




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Foreign key referential action timing
Next
From: "Marc G. Fournier"
Date:
Subject: Upcoming v8.0.0 Beta 4 ...