Joshua D. Drake wrote:
On Fri, 2006-12-29 at 13:21 -0500, James Neff wrote:
Joshua D. Drake wrote:
Also as you are running 8.2 you can use multi valued inserts...
INSERT INTO data_archive values () () ()
Would this speed things up? Or is that just another way to do it?
The fastest way will be copy.
The second fastest will be multi value inserts in batches.. eg.;
INSERT INTO data_archive values () () () (I don't knwo what the max is)
but commit every 1000 inserts or so.
Sincerely,
Joshua D. Drake
Thanks,
James
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Another thing....if you have to make validations and so on....creating
an temp file with the information validated and using COPY will be
faster. So you can validate and use COPY at the same time....
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
