Postgres/Perl performance help needed

[Jim Rootham]

Hi Madison

Is there associated data in the database that must be maintained?
Or are there records which may not be deleted?

If neither I would suggest starting with empty tables and updating
without checks or indices.  Create the index after for lookup purposes.

If you need to hang on to existing data you might try to load a temp table
and create a new table using just SQL using a subquery to generate the
data.    It's not really clear if this is faster in total.   Performance issues
are like that.

Jim
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml