PostgreSQL Generated Columns by Example | POSETTE: An Event for Postgres 2026

Why watch

This video explores PostgreSQL generated columns through practical examples, focusing on the virtual-by-default behavior introduced in PostgreSQL 18. It covers trade-offs between virtual and stored generated columns, their evolution across PostgreSQL versions, and demonstrates how Django 6.0 exposes these features through its ORM. The talk is ideal for backend developers using Python/Django with PostgreSQL who want to understand when and how to leverage generated columns in production systems.