Re: [PERFORM] pgsql inserts problem

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Bruno Wolff III" <bruno(at)wolff(dot)to>, "Tarhon-Onu Victor" <mituc(at)iasi(dot)rdsnet(dot)ro>
Cc: <pgsql-bugs(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORM] pgsql inserts problem
Date: 2003-08-28 04:01:37
Message-ID: 039101c36d19$146ca3e0$2800a8c0@mars
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

> > 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.

I wouldn't be surprised, MySQL will just insert a zero instead of failing in
most cases :P

Chris

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Wiseguy 2003-08-28 04:22:10 Re: Install postgresql 7.3 on Solaris 2.6 sparc
Previous Message Bruno Wolff III 2003-08-28 03:23:56 Re: [PERFORM] pgsql inserts problem

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Johnson 2003-08-28 04:07:35 Re: Hardware recommendations to scale to silly load
Previous Message Bruno Wolff III 2003-08-28 03:23:56 Re: [PERFORM] pgsql inserts problem