Postgres Pro
Downloads
Home   >   mailing lists

Re: Pre-set Hint bits/VACUUM FREEZE on data load..? - Mailing list pgsql-hackers

From Marti Raudsepp
Subject Re: Pre-set Hint bits/VACUUM FREEZE on data load..?
Date
Msg-id AANLkTi=Auc_qbt-HgJWvMWc8ZF=O4gaStPwYBa0NG4Mf@mail.gmail.com
Whole thread Raw
In response to Re: Pre-set Hint bits/VACUUM FREEZE on data load..?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Tree view 
On Thu, Mar 24, 2011 at 23:47, Stephen Frost <sfrost@snowman.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

pgsql-hackers by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: 2nd Level Buffer Cache
Next
From: yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi)
Date:
Subject: Re: SSI bug?