Received: from web2105.mail.yahoo.com (web2105.mail.yahoo.com [128.11.68.249])
	by hub.org (8.9.3/8.9.3) with SMTP id DAA94553
	for <pgsql-interfaces@postgresql.org>;
	Tue, 11 Jan 2000 03:23:05 -0500 (EST)
	(envelope-from mickaelfeys@yahoo.com)
Received: (qmail 24781 invoked by uid 60001); 11 Jan 2000 08:23:04 -0000
Message-ID: <20000111082304.24780.qmail@web2105.mail.yahoo.com>
Received: from [194.117.218.130] by web2105.mail.yahoo.com;
	Tue, 11 Jan 2000 00:23:04 PST
Date: Tue, 11 Jan 2000 00:23:04 -0800 (PST)
From: =?iso-8859-1?q?FEYS=20Mickael?= <mickaelfeys@yahoo.com>
Subject: Performance problem with the lo_create function
To: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

I use Postgres-6.5.3 and I would like to know why the
lo_create function takes 1 second to find a free oid ?

The problem is that I want to insert 2000 large objets
in a database but it takes me about 40 min which is
too much time.

Best regards,
Mickael.
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com