Excellent, many thanks Jeremy. On Friday, 9 June 2017 14:46:38 UTC+1, Jeremy Evans wrote: > > On Friday, June 9, 2017 at 2:45:40 AM UTC-7, Bruce Steedman wrote: >> >> Apologies if this subject has been covered already, if so please point me >> at the appropriate post/guide. >> >> I need to bulk insert data into an existing PostgreSQL database (v9.6) >> and came across this excellent guide >> <https://stackoverflow.com/questions/12206600/how-to-speed-up-insertion-performance-in-postgresql> >> >> on SO. The operation is time-critical, so am I best avoiding ORM layer, or >> can I use Sequel to accomplish very fast bulk data inserts & if so how? >> > > Sequel offers Database#copy_into on PostgreSQL for adding data to a table > using COPY FROM STDIN. You can also do INSERT with multiple rows using > Dataset#import, but it probably won't be as fast. For the fastest > operation, you may want to use the pg driver directly, or use a tool > written in C such as psql. > > Thanks, > Jeremy >
-- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
