Skip site navigation (1) Skip section navigation (2)

Re: code question: storing INTO relation

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Gavin Sherry" <swm(at)linuxworld(dot)com(dot)au>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Neil Conway" <neilc(at)samurai(dot)com>,"pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: code question: storing INTO relation
Date: 2004-10-21 21:54:33
Message-ID: 003401c4b7b8$8e1fca10$06e887d9@Nightingale (view raw or flat)
Thread:
Lists: 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



In response to

Responses

pgsql-hackers by date

Next:From: Chris BrowneDate: 2004-10-21 21:55:12
Subject: Slony-I 1.0.4 Released
Previous:From: Tom LaneDate: 2004-10-21 21:36:36
Subject: Re: Foreign key referential action timing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group