Postgres Pro
Downloads
Home   >   mailing lists

Fastest way to load data in a table - Mailing list pgsql-general

From Antonio Navarro Navarro
Subject Fastest way to load data in a table
Date
Msg-id 880141477.20010926111710@bemarnet.es
Whole thread Raw
Responses Re: Fastest way to load data in a table
List pgsql-general
Tree view 
Hi all.

I need to clean and fill periodically a database with several hundred thousands
records readed from a plain ascii file.

I have a Python script that opens the file and then, after a 'DELETE *
FROM table'  submits an INSERT for each registry, but this process is very slow.

How can I accelerate this uploading process ?

Best regards,

Antonio Navarro Navarro
BemarNet Management
http://www.bemarnet.es
hostmaster@bemarnet.es

pgsql-general by date:

Previous
From: tony
Date:
Subject: Re: Multibyte FAQ item
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Fastest way to load data in a table