Hi, there,
I tried different ways, include vaccum table , ensure index works, it
still is as slow as ~100rows per minute.
Stephan Szabo wrote:
> 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?
--
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang@ipinc.com
www.ipinc.com