From: Rolf Lüttecke <rluettecke@gcd.de>
To: pgsql-interfaces@postgresql.org
Subject: Slow down on Import
Date: Wed, 12 Jan 2000 17:45:05 +0100
Message-ID: <009201bf5d1c$60bf9920$8104a8c0@gcdw4129.gcd.de> (raw)
Hi folks,
first some techn. data: SNI-Primergy w/ PII-333, 128Meg and
SCSI-devices, Linux 2.0.36
The following strange behaviour comes up since upgrading to
version 6.5.3 + FreeFile-Patch (hi Tom):
When re-importing a dumped database the job is normally done
in roundabout 8 seconds. When you drop the database and
repeat the step a few times, the speed slows down to at least
1.5 minutes.
Example:
# for i in 1 2 3 4 5
# do
# destroydb xyz
# createdb xyz
# time psql xyz < ./import.db (small table / 10.000 rows)
# (output from time: 8.2 seconds up to 1.5 minutes)
# done
There is no additional load on that machine. The main application
(MS-Access w/ ODBC xx.0006) seems sleeping during database-
search - so we tried to figure out the problem and made at least
the above test directly on that machine. Last hint: A complete
copy from "/opt/pgsql" transferred to a another machine shows
the same problem.
What´s wrong? Any ideas?
Regards
-Rolf
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-interfaces@postgresql.org
Cc: rluettecke@gcd.de
Subject: Re: Slow down on Import
In-Reply-To: <009201bf5d1c$60bf9920$8104a8c0@gcdw4129.gcd.de>
* 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