Re: import performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: import performance
Date
Msg-id 12028.1142301081@sss.pgh.pa.us
Whole thread Raw
In response to Re: import performance  (Chris <dmagick@gmail.com>)
Responses Re: import performance
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Chris
Date:
Subject: Re: import performance
Next
From: Frank Wiles
Date:
Subject: Re: import performance