Re: import performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris <dmagick(at)gmail(dot)com>
Cc: Frank Wiles <frank(at)wiles(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: import performance
Date: 2006-03-14 01:51:21
Message-ID: 12028.1142301081@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Chris <dmagick(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Frank Wiles 2006-03-14 01:57:27 Re: import performance
Previous Message Chris 2006-03-14 01:42:21 Re: import performance