> Of course, I checked the error status for every insert, there is > no error. It seems like in my case the postgres server cannot handle so > much inserts per second some of the lines are not being parsed and data > inserted into the database.
That sounds extremely unlikely. Postgres is not one to fail without any sort of error. There's something else that is the problem. More than likely, it's a problem in your code. Chris ---------------------------(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