Re: pgsql inserts problem - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: pgsql inserts problem
Date
Msg-id 039101c36d19$146ca3e0$2800a8c0@mars
Whole thread Raw
In response to pgsql inserts problem  (Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>)
List 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


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sun vs a P2. Interesting results.
Next
From: Ron Johnson
Date:
Subject: Re: Hardware recommendations to scale to silly load