5 Ways to Improve Your PostgreSQL INSERT performance

Timescale Developer Advocate @avthars breaks down factors that impact #PostgreSQL ingest rate and 5 (immediately actionable) techniques to improve your databases’ speed.

You’ll learn why ingest rate is so critical to #timeseries data and get step-by-step demos, tips, and resources to apply each optimization technique to your database instances and projects.

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Find pgcopy installation and how-to ⇒ https://tsdb.co/python-how-to
📌 Check out all 13 tips ⇒ https://tsdb.co/more-tips
📌 Explore Time-Series Benchmarking Suite ⇒ https://github.com/timescale/tsbs
📌 Join Timescale Developer Slack ⇒ https://tsdb.co/TimescaleSlack
📌 Start a free Timescale Cloud trial ($300 in cloud credits to start 🎉) ⇒ https://tsdb.co/cloud-trial

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
At Timescale, we are dedicated to serving developers worldwide, enabling them to build exceptional data-driven products that measure everything that matters. Analyzing this data across the time dimension (“time-series data”) enables developers to understand what is happening right now, how that is changing, and why that is changing. We are backed by top-tier investors with a track record of success in the industry.

💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!
🔍 Website ⇒ https://tsdb.co/homepage
🔍 Slack ⇒ https://slack.timescale.com
🔍 GitHub ⇒ https://github.com/timescale
🔍 Twitter ⇒ https://twitter.com/timescaledb
🔍 Twitch ⇒ https://www.twitch.tv/timescaledb
🔍 LinkedIn ⇒ https://www.linkedin.com/company/timescaledb
🔍 Timescale Blog ⇒ https://tsdb.co/blog
🔍 Timescale Documentation ⇒ https://tsdb.co/docs

📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 0:00 ⇒ Introduction
⏱ 2:35 ⇒ Roadmap & motivation: what you’ll learn and why it matters
⏱ 7:05 ⇒ Demo scenario, dataset, and machine specs
⏱ 11:25 ⇒ Tip #1: Batch Insert
⏱ 20:56 ⇒ Tip #2: Parallel Writes
⏱ 27:20 ⇒ Tip #3: Use Performant Disks
⏱ 32:46 ⇒ Tip #4: Use Separate Disks for WAL & Data
⏱ 34:25 ⇒ Tip #5: Use TimescaleDB 🙂
⏱ 38:30 ⇒ (Bonus) Tip #6: Write Data in Loose Time Order
⏱ 40:46 ⇒ Recap & Resources