Re: import performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Chris <dmagick@xxxxxxxxx> 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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux