On Tue, 29 Aug 2000, Jie Liang wrote:
> Hi, there,
>
> 1. use copy ... from '.....';
> 2. write a PL/pgSQL function and pass multiple records as an array.
>
> However, if your table have a foreign key constraint, it cannot be speed
> up,
>
> I have same question as you, my table invloving 9-13 million rows, I
> don't
> know how can I add a foreign key them also?
I haven't tried it on really large tables, but does it turn out faster to
use ALTER TABLE ADD CONSTRAINT to add the foreign key constraint after the
data is loaded and the indexes are created?