From: Chris <dmagick@gmail.com>
To: Frank Wiles <frank@wiles.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: import performance
Date: Tue, 14 Mar 2006 12:42:21 +1100
Message-ID: <44161F7D.9070707@gmail.com> (raw)
In-Reply-To: <20060313193318.61709662.frank@wiles.org>
References: <441610EB.7070001@gmail.com>
<Pine.LNX.4.58.0603141146130.16333@linuxworld.com.au>
<44161B46.5050801@gmail.com>
<20060313193318.61709662.frank@wiles.org>
Frank Wiles wrote:
> On Tue, 14 Mar 2006 12:24:22 +1100
> Chris <dmagick@gmail.com> wrote:
>
>
>>Gavin Sherry wrote:
>>
>>>On Tue, 14 Mar 2006, Chris wrote:
>>>
>>>
>>>
>>>>Hi all,
>>>>
>>>>I'm trying to work out why my 8.1 system is slower than my 7.4
>>>>system for importing data.
>>>>
>>>>The import is a lot of "insert into" commands - it's a converted
>>>>database from another system so I can't change it to copy commands.
>
>
> Are you on the same hardware specifically in your disk subsystem?
> Anything else different about how the two servers are used?
Different hardware.
7.4 is running on a 500MHz computer with 256M compared to 8.1 running on
a 2.6GHz with 512M.
The only notable config variables on that machine (the rest are logging):
commit_delay = 10000
checkpoint_segments = 10
checkpoint_warning = 300
insert times:
Time: 63.756 ms
INSERT 13584074 1
Time: 46.465 ms
INSERT 13584075 1
Time: 70.518 ms
INSERT 13584077 1
Time: 59.864 ms
INSERT 13584078 1
Time: 35.984 ms
Tons of difference :/
--
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, frank@wiles.org
Subject: Re: import performance
In-Reply-To: <44161F7D.9070707@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