Copy Questions

From: "Chad Thompson" <chad(at)weblinkservices(dot)com>
To: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Copy Questions
Date: 2003-01-24 21:28:09
Message-ID: 01f301c2c3ef$7e91f550$32021aac@chad
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have csv files that are sent to me on a regular basis. ~ 50k records a piece.
I have been simply using insert to date, but wonder if copy would give me better performance.

My questions are:
1) If I use copy, the docs suggest that I copy to a temp table then insert into mytable from temptable, in order for the sequence to fire.
Does the copy of 7.3 allow sequences to fire during copy?

2) The docs also suggest that I drop my indexes and reindex.
Would I need to do this if i copy to a temp table and insert? (would it make it that much faster?)

3) The idocs didnt seem to show much in the way of examples. Is there a better site?

The table to which I am inserting is currently >4M records and grow(n)ing.

Any suggestions would be appreciated

TIA
Chad

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Devinder K Rajput 2003-01-24 21:59:39 Re: Can't read input file
Previous Message Oliver Elphick 2003-01-24 18:30:19 Re: Can't read input file