X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 92F90D1B97C for ; Thu, 28 Aug 2003 03:18:31 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 23894-08 for ; Thu, 28 Aug 2003 00:17:59 -0300 (ADT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 1D923D1B8CC for ; Thu, 28 Aug 2003 00:17:59 -0300 (ADT) Received: (qmail 7371 invoked by uid 500); 28 Aug 2003 03:23:56 -0000 Date: Wed, 27 Aug 2003 22:23:56 -0500 From: Bruno Wolff III To: Tarhon-Onu Victor Cc: pgsql-bugs@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [PERFORM] pgsql inserts problem Message-ID: <20030828032356.GC7185@wolff.to> Mail-Followup-To: Tarhon-Onu Victor , pgsql-bugs@postgresql.org, pgsql-performance@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/235 X-Sequence-Number: 6607 On Wed, Aug 27, 2003 at 15:50:32 +0300, Tarhon-Onu Victor wrote: > > The problems is that only ~15% of the lines are inserted into > the database. The same script modified to insert the same data in a > similar table created in a MySQL database inserts 100%. Did you check the error status for the records that weren't entered? My first guess is that you have some bad data you are trying to insert.