Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id AAA11213
	for <pgsql-interfaces@postgreSQL.org>;
	Sun, 16 Jan 2000 00:24:55 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id AAA18562;
	Sun, 16 Jan 2000 00:24:45 -0500 (EST)
To: "=?iso-8859-1?Q?Rolf_L=FCttecke?=" <rluettecke@gcd.de>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Slow down on Import 
In-reply-to: <009201bf5d1c$60bf9920$8104a8c0@gcdw4129.gcd.de> 
References: <009201bf5d1c$60bf9920$8104a8c0@gcdw4129.gcd.de>
Comments: In-reply-to "=?iso-8859-1?Q?Rolf_L=FCttecke?=" <rluettecke@gcd.de>
	message dated "Wed, 12 Jan 2000 17:45:05 +0100"
Date: Sun, 16 Jan 2000 00:24:45 -0500
Message-ID: <18559.948000285@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

"=?iso-8859-1?Q?Rolf_L=FCttecke?=" <rluettecke@gcd.de> writes:
> # 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

Hmm.  I tried to reproduce this behavior, but didn't see it on either
6.5.* or current sources.  Does anyone else see it?

			regards, tom lane