I didn't think mulitple backends worked.
In addition to that, you can try inserting from multiple backends simaltenously to speed up the whole process.
And I don't like the modes idea OP gave. I would rather follow insert->if-error-update mode in a transaction for each record. And fork over say 20/40 parallel backends to achieve good speed.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
