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.
