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