Re: Pre-set Hint bits/VACUUM FREEZE on data load..?

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Pre-set Hint bits/VACUUM FREEZE on data load..?
Date: 2011-03-25 15:13:48
Message-ID: AANLkTi=Auc_qbt-HgJWvMWc8ZF=O4gaStPwYBa0NG4Mf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 24, 2011 at 23:47, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> I'd be happy with a "data loading mode" that even disallowed
> subtransactions if necessary to achieve the write-once (well, plus WAL
> if you're archiving) operation...

Note that there's already an extension on pgFoundry for a "data
loading mode", have you looked at pg_bulkload?

http://pgbulkload.projects.postgresql.org/

Regards,
Marti

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-03-25 15:32:24 Re: Re: making write location work (was: Efficient transaction-controlled synchronous replication)
Previous Message Gurjeet Singh 2011-03-25 15:07:00 Re: 2nd Level Buffer Cache