From: | Alberto Caso <alberto(dot)caso(at)adaptia(dot)net> |
---|---|
To: | Juan Francisco Diaz <j-diaz(at)publicar(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How to opimize the insertion of data |
Date: | 2003-09-10 06:03:07 |
Message-ID: | 1063173786.2993.35.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, 09-09-2003 at 23:05, Juan Francisco Diaz wrote:
> Hi, have tried by all means to optimize the insertion of data in my db but
> it has been impossible.
> Righto now to insert around 300 thou records it takes soemthing like 50 to
> 65 minutes (too long).
Try enclosing your inserts into transactions of several thousands of
inserts, i.e:
begin;
(several thousands of inserts)
commit;
...
You may also want to have a look at the COPY command:
http://developer.postgresql.org/docs/postgres/sql-copy.html
Have also a look at:
http://www.postgresql.org/docs/7.3/interactive/populate.html
Best regards,
--
Alberto Caso Palomino
Adaptia Soluciones Integrales
http://www.adaptia.net
alberto(dot)caso(at)adaptia(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Erwan DUROSELLE | 2003-09-10 07:50:02 | Rp. : How to opimize the insertion of data |
Previous Message | Gaetano Mendola | 2003-09-10 02:44:01 | Re: Concatenating string fields with GROUP BY clause |