Re: import performance

From: Frank Wiles <frank(at)wiles(dot)org>
To: Chris <dmagick(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: import performance
Date: 2006-03-14 01:57:27
Message-ID: 20060313195727.78df3adc.frank@wiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 14 Mar 2006 12:42:21 +1100
Chris <dmagick(at)gmail(dot)com> wrote:

> Different hardware.
>
> 7.4 is running on a 500MHz computer with 256M compared to 8.1 running
> on a 2.6GHz with 512M.

Well when it comes to inserts CPU and RAM have almost nothing to do
with it. What are the hard disk differences? Does the old server
have fast SCSI disk and the new box SATA? Or the old server was
on a RAID volume and the new one isn't, etc... those are the sort
of hardware differences that are important in this particular
case.

---------------------------------
Frank Wiles <frank(at)wiles(dot)org>
http://www.wiles.org
---------------------------------

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Chris 2006-03-14 02:27:28 Re: import performance
Previous Message Tom Lane 2006-03-14 01:51:21 Re: import performance