Christopher Petrilli <[EMAIL PROTECTED]> writes: > http://blog.amber.org/diagrams/comparison_mysql_pgsql.png
> Notice the VERY steep drop off. Hmm. Whatever that is, it's not checkpoint's fault. I would interpret the regular upticks in the Postgres times (every several hundred iterations) as being the effects of checkpoints. You could probably smooth out those peaks some with appropriate hacking on bgwriter parameters, but that's not the issue at hand (is it?). I have no idea at all what's causing the sudden falloff in performance after about 10000 iterations. COPY per se ought to be about a constant-time operation, since APPEND is (or should be) constant-time. What indexes, foreign keys, etc do you have on this table? What else was going on at the time? regards, tom lane ---------------------------(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