Kevin Keith wrote:
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).
If you have enough memory, you can always make a ramdisk to store the
WAL temporarily while you bulk load data. I also temporarily alter the
config to set checkpoint_segments = 1 to use as few pg_xlog files as
possible.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
