bug

From: Sandeep Joshi <sjoshi(at)Zambeel(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: bug
Date: 2000-12-04 20:50:59
Message-ID: 3A2C03B3.D6A0207D@zambeel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I was trying to populate a database from an ascii file using copy
command.

table had 5 columns and 2 of them had "references" column and 3 of
them were involved in
primary key clause. I was trying to populate 1 million rows.

The process didn't finish for 12 hours !!!

But, when removed foreign keys and primary keys it took less than
10-20 minutes.

Also, if a particular didn't qualify from the "data" file then whole
process would abort.
I think it should skip that row and continue.

thanks,
Sandeep

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-12-04 21:10:08 Re: Re: Why PostgreSQL is not that popular as MySQL?
Previous Message Joel Bernstein 2000-12-04 20:34:46 Docs for beta 7.1