> 1. fork your import somhow to get all 4 cores running
This is already happening, albeit only 3. No improvement - it appears we
have taken the same problem, and divided it by 3. Same projected completion
time. this is really curious, to say the least.
> 2. write the code that actually does the insert in C and use the
> parameterized prepared statement.
I had already tried the paremetrised prepare statement; I had mentioned that
I was surprised that it had no effect. No one here seemed surprised, or at
least didn't think of commenting on it.
> however, your general approach has been 'please give me advice, but
> only the advice that i want'.
I'm sorry I don't understand - I had actually originally come asking four
questions asking for recommendations and opinions on hardware, O/S and
commercial support. I did also ask for comments on my config setup.
---------------------------(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
