Fastest way to load data in a table

From: Antonio Navarro Navarro <hostmaster(at)bemarnet(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: Fastest way to load data in a table
Date: 2001-09-26 09:17:10
Message-ID: 880141477.20010926111710@bemarnet.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)bemarnet(dot)es

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2001-09-26 10:40:47 Re: Fastest way to load data in a table
Previous Message tony 2001-09-26 08:09:32 fun in redmond