From: | Jie Liang <jliang(at)ipinc(dot)com> |
---|---|
To: | Webb Sprague <wsprague100(at)yahoo(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Optimizing huge inserts/copy's |
Date: | 2000-08-30 01:39:50 |
Message-ID: | 39AC65E6.851BBC64@ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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?
Webb Sprague wrote:
> Hi all,
>
> Does anybody have any thoughts on optimizing a huge
> insert, involving something like 3 million records all
> at once? Should I drop my indices before doing the
> copy, and then create them after? I keep a
> tab-delimited file as a buffer, copy it, then do it
> again about 400 times. Each separate buffer is a few
> thousand records.
>
> We do this at night, so it's not the end of the world
> if it takes 8 hours, but I would be very grateful for
> some good ideas...
>
> Thanks
> W
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
--
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang(at)ipinc(dot)com
www.ipinc.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2000-08-30 01:50:53 | Re: Create Primary Key? |
Previous Message | Stephan Szabo | 2000-08-30 01:10:23 | Re: Create Primary Key? |