Chris <dmagick@gmail.com> writes:
> Tons of difference :/
Have you checked that the I/O performance is comparable? It seems
possible that there's something badly misconfigured about the disks
on your new machine. Benchmarking with "bonnie" or some such would
be useful; also try looking at "iostat 1" output while running the
inserts on both machines.
Also, are the inserts just trivial "insert values (... some constants ...)"
or is there more to it than that?
regards, tom lane