I am trying to speed up a couple of decent sized inserts (~25K rows a
pop) by using COPY FROM.
A slight snag I am running into is that the table I insert into has a
primary key generated from a sequence.
So I want to include this id in the temp text file that I copy from, so
what is the proper way to grab 25K or so values from a sequence, without
breaking anything?
In other words, if I get $current_val with "nextval('foo')" and then do
a "setval('foo', $current_val + 25000)", that creates a race condition.
The only other thing I can think of is "setval('foo', nextval('foo') +
25000)", but then I can't get the actual start value out (and I am not
even sure this would be truly atomic).
What's the proper way of doing this? Calling nextval for every row when
I create the temp file seems to somehow go against the idea of speeding
things up...
thanks,
Dmitri