From: Frank Wiles <frank@wiles.org>
To: Chris <dmagick@gmail.com>
Cc: swm@alcove.com.au
Cc: pgsql-performance@postgresql.org
Subject: Re: import performance
Date: Mon, 13 Mar 2006 19:33:18 -0600
Message-ID: <20060313193318.61709662.frank@wiles.org> (raw)
In-Reply-To: <44161B46.5050801@gmail.com>
References: <441610EB.7070001@gmail.com>
<Pine.LNX.4.58.0603141146130.16333@linuxworld.com.au>
<44161B46.5050801@gmail.com>
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?
---------------------------------
Frank Wiles <frank@wiles.org>
http://www.wiles.org
---------------------------------
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: frank@wiles.org, dmagick@gmail.com, swm@alcove.com.au
Subject: Re: import performance
In-Reply-To: <20060313193318.61709662.frank@wiles.org>
* 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