Optimizing For Time-Series Data | Scaling Postgres 362
Join Over 1,000 Engineers & Get New Episodes Weekly!
In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving low cardinality data columns.
Content Discussed
- Time-series considerations
- Indexing vectors in PostgreSQL
- Mini Summit 3 Transcript: Apt Extension Packaging
- Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restore
- Waiting for PostgreSQL 18 – Add modern SHA-2 based password hashes to pgcrypto.
- pg_dump Gets a Speed Boost in PostgreSQL 18
- User, User, Who Is the User?
- Boosting Postgres' EXPLAIN
- Improvements in Expanded Objects in PostgreSQL 18
- Of Unicorns and Donkeys
- Finding Bottlenecks and Avoiding Over-Optimization via Explain Plans
- Postgres Protocol and a Side Quest
- Fix Postgres strchrnul Compile Error on macOS 15.4
- PgPedia Week, 2025-04-06
- PgPedia Week, 2025-04-13
- When Your IoT Data Outgrows Your Architecture
- Connecting Ruby and PostgreSQL: Timescale Integrations Expand
- Bringing MCP to the Cloud
- The True Cost of Slow Postgres Restores
- Provision Postgres at Scale with the Neon API
- Modern Startup Stack Architecture on Azure
YouTube Video
Podcast Audio
