From: Chris <dmagick@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Frank Wiles <frank@wiles.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: import performance
Date: Tue, 14 Mar 2006 13:27:28 +1100
Message-ID: <44162A10.7080205@gmail.com> (raw)
In-Reply-To: <12028.1142301081@sss.pgh.pa.us>
References: <441610EB.7070001@gmail.com>
<Pine.LNX.4.58.0603141146130.16333@linuxworld.com.au>
<44161B46.5050801@gmail.com>
<20060313193318.61709662.frank@wiles.org>
<44161F7D.9070707@gmail.com>
<12028.1142301081@sss.pgh.pa.us>
Tom Lane wrote:
> 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.
I'll check out bonnie, thanks.
hdparm shows a world of difference (which I can understand) - that being
the old server is a lot slower.
hdparm -t /dev/hda
/dev/hda:
Timing buffered disk reads: 24 MB in 3.13 seconds = 7.67 MB/sec
hdparm -T /dev/hda
/dev/hda:
Timing cached reads: 596 MB in 2.00 seconds = 298.00 MB/sec
Newer server:
hdparm -t /dev/hda
/dev/hda:
Timing buffered disk reads: 70 MB in 3.02 seconds = 23.15 MB/sec
hdparm -T /dev/hda
/dev/hda:
Timing cached reads: 1512 MB in 2.00 seconds = 754.44 MB/sec
> Also, are the inserts just trivial "insert values (... some constants ...)"
> or is there more to it than that?
Straight inserts, no foreign keys, triggers etc.
The only other thing I can see is the old server is ext2:
/dev/hda4 on / type ext2 (rw,errors=remount-ro)
the new one is ext3:
/dev/hda2 on / type ext3 (rw)
If it's a server issue not a postgres issue I'll keep playing :) I
thought my config was bad but I guess not.
Thanks for all the help.
--
Postgresql & php tutorials
http://www.designmagick.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dmagick@gmail.com, tgl@sss.pgh.pa.us, frank@wiles.org
Subject: Re: import performance
In-Reply-To: <44162A10.7080205@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox