PostgreSQL Generated Columns by Example | POSETTE: An Event for Postgres 2026
Postgresql Generated columns Virtual columns Stored columns Django orm Postgresql 18 Python Database optimization Database design Django 6.0
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.