From: | "Martin Hampl" <Martin(dot)Hampl(at)gmx(dot)de> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Turn off Wal for bulk loaf input |
Date: | 2004-05-30 10:30:14 |
Message-ID: | 23540.1085913014@www41.gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I am sorry if this question has been asked before hundreds of times, but I
couldn't find an answer in the archive.
I want to bulk load several GBs of data to an empty table. My concerns are
time and disk space, mainly time. I don't care about transactions (for this
particular purpose) if I can save any time on the input.
I thought I read somewhere that setting fsync to "off" does prevent wal,
however, it does not seems so.
What wal settings result in optimal performance (not caring about disk
space)? I set checkpoint_timeout to 3600 and checkpoint_segments to 1000,
but I am not sure I completely understand what the consequences are :)
Regards,
Martin
--
+++ Jetzt WLAN-Router fr alle DSL-Einsteiger und Wechsler +++
GMX DSL-Powertarife zudem 3 Monate gratis* http://www.gmx.net/dsl
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2004-05-30 17:19:23 | Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it? |
Previous Message | Oliver Elphick | 2004-05-30 05:39:49 | Re: Copy from problem |