Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-performance by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group