Microsoft Courses

New Features of the Odyssey Connection Pooler

Explore Odyssey 1.3’s transaction pooling features, including standby lag polling and prepared statement pooling, for PostgreSQL workloads.

• YouTube
• 30 minutes
• Self-Paced
• Free Video

Fibonacci Spirals and 18 Ways to Contribute to Postgres Beyond Code

Learn 18 ways to contribute to the Postgres community beyond code, including documentation, content creation, meetups, talks, mentoring, and fundraising.

• YouTube
• 32 minutes
• Self-Paced
• Free Video

Queues in PostgreSQL - Building and Optimizing Database Job Queues

Explores how to build and scale job queues in a single PostgreSQL database using locking, concurrency, isolation, indexing, and benchmarking.

• YouTube
• 30 minutes
• Self-Paced
• Free Video

Localization in PostgreSQL - Implementing Multi-Language Support

Explore how PostgreSQL collations shape multilingual sorting order and query performance across Japanese, Chinese, and English data.

• YouTube
• 29 minutes
• Self-Paced
• Free Video

Explaining the Postgres Query Optimizer

Explains how PostgreSQL’s query optimizer chooses scan and join methods, using EXPLAIN to reveal and improve query plans.

• YouTube
• 29 minutes
• Self-Paced
• Free Video

Building Geospatial Apps on Postgres, PostGIS, & Citus at Large Scale

A case study in scaling 25 TB of real-time geospatial insurance analytics with PostGIS spatial indexing and Citus sharding on Azure.

• YouTube
• 30 minutes
• Self-Paced
• Conference Talk

Choosing the Right Shard Key for Efficiently Distributing Postgres with Citus

Learn how to choose an effective Citus distribution column to shard PostgreSQL data using workload, schema, cardinality, and co-location considerations.

• YouTube
• 28 minutes
• Self-Paced
• Free Video

How Secure Is Your Database? Hacking Postgres with Hathi - Network Security and Authentication

Learn to use Hathi password spraying to uncover insecure PostgreSQL configurations and strengthen database network security.

• YouTube
• 30 minutes
• Self-Paced
• Free Video

Analyzing Postgres Performance Problems Using Perf and eBPF

Learn to investigate PostgreSQL performance problems in production with Linux perf and eBPF, combining system-wide profiling, tracing, and pg_stat_statements.

• YouTube
• 27 minutes
• Self-Paced
• Free Video

The Building Blocks for Self-Driving PostgreSQL

Explores the engineering building blocks PostgreSQL needs to become a self-driving database through workload capture, telemetry, and control APIs.

• YouTube
• 33 minutes
• Self-Paced
• Free Video

8 Keys to the Growth of Citus and Distributed PostgreSQL - Keynote

A keynote on how Citus turned PostgreSQL into an open-source, horizontally scalable distributed database—and the product, community, and cloud choices behind its growth.

• YouTube
• 32 minutes
• Self-Paced
• Free Video

Citus Cluster Zero-Downtime Migration - Algolia's Experience

A case study of migrating Algolia’s 5 TB Citus analytics database from Citus Cloud to Azure with minimal downtime.

• YouTube
• 28 minutes
• Self-Paced
• Free Video

Developing IO Prefetching for PostgreSQL

Explore how PostgreSQL engineers simulate and refine a feedback-adjusted prefetching algorithm for direct and asynchronous I/O.

• YouTube
• 30 minutes
• Self-Paced
• Free Video

PostgreSQL - More Relevant Than Ever

A keynote examining why PostgreSQL remains relevant through its open-source model, extensibility, and evolving role in modern IT.

• YouTube
• 30 minutes
• Self-Paced
• Free Video

Lesser Known Features of PostgreSQL

A tour of lesser-known PostgreSQL features for upserts, reproducible test data, complex strings, constraints, and practical psql workflows.

• YouTube
• 30 minutes
• Self-Paced
• Free Video