FAQ
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 für alle DSL-Einsteiger und Wechsler +++
GMX DSL-Powertarife zudem 3 Monate gratis* http://www.gmx.net/dsl

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedMay 30, '04 at 10:30a
activeMay 30, '04 at 10:30a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Martin Hampl: 1 post

People

Translate

site design / logo © 2021 Grokbase