Name: Bulk inserts with PostgreSQL: Four methods for efficient data loading
Start: 2021-12-01T11:45:00+0000
End: 2021-12-01T12:25:00+0000

Back To Schedule

Bulk inserts with PostgreSQL: Four methods for efficient data loading

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.

Speakers

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
TBA

PostgreSQL Tools and Features

Postgres Build 2021

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

Ryan Booz