Re: How to opimize the insertion of data

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