>>>>> "sm" == scott marlowe <scott.marlowe> writes:
sm> also, turning off fsync during the load helps a lot. Be sure to turn it
sm> back on when you're done of course.
Only if you don't have a battery-backed cache on your RAID. If you
do, it won't likely make a big difference. For me it was about 2
seconds over a 4-hour restore.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
