From: | "Kevin Keith" <kevinrkeith(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Disabling WAL for bulk data loads |
Date: | 2005-09-09 16:02:33 |
Message-ID: | BAY108-F115459FF84EB8232582111B9980@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I am coming from an Oracle background - which in the case of bulk data loads
there were several options I had where I could disable writing to the redo
log to speed up the bulk data load (i.e. direct load, set the user session
in no archive logging, set the affected tables to have no logging).
I know the COPY command is one option - however it appears the data would
need to be in formatted file in order to use it correct? I want to avoid
writing a new file out for the COPY command and loading that.
What other options does Postgres 7.4 provide which would allow data loads to
bypass writing to the WAL? I don't need to have this enabled - because in
the event of a database crash, I would simply reload the data from the
source files as recovery.
Thanks,
Kevin
_________________________________________________________________
Dont just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2005-09-09 17:14:28 | Re: Disabling WAL for bulk data loads |
Previous Message | Tom Lane | 2005-09-09 15:07:53 | Re: could not locate a valid checkpoint record |