| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| 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 03:23:56 |
| Message-ID: | 20030828032356.GC7185@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-performance |
On Wed, Aug 27, 2003 at 15:50:32 +0300,
Tarhon-Onu Victor <mituc(at)iasi(dot)rdsnet(dot)ro> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-08-28 04:01:37 | Re: [PERFORM] pgsql inserts problem |
| Previous Message | Tom Lane | 2003-08-28 03:09:50 | Re: psql does not pick up hostname without -h even though they ae the same |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-08-28 04:01:37 | Re: [PERFORM] pgsql inserts problem |
| Previous Message | Tom Lane | 2003-08-28 03:15:35 | Re: Sun vs a P2. Interesting results. |