Postgres Build 2021 has ended
Back To Schedule
Wednesday, December 1 • 11:45am - 12:25pm
Bulk inserts with PostgreSQL: Four methods for efficient data loading

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Inserting bulk data into PostgreSQL is a task many engineers have to do, but knowing how to do it efficiently can be a challenge. In this talk we will discuss four ways to insert data at high rates using: the built-in COPY command, language SDKs, multi-valued INSERT statements, and even a trick that incorporates array parameters that can outperform other options in some circumstances. We'll also discuss the impact of each option on server resources and the overall impact to the database being modified.

avatar for Ryan Booz

Ryan Booz

Director, Developer Advocacy, Timescale
Ryan is a Developer Advocate at Timescale, the supercharged time-series database built on PostgreSQL. Prior to Timescale, Ryan worked for more than 17 years as a developer, DBA, and product manager in multiple ISVs delivering SaaS products based on time-series data. Ryan is a long-time... Read More →

Wednesday December 1, 2021 11:45am - 12:25pm GMT