No video of the event yet, sorry!

Checkout the slides

The talk will cover why the order of columns in a table can matter in specific scenarios, affecting both performance and maintainability. It will highlight how placing fixed-length columns (e.g., INT, DATE) before variable-length columns (e.g., TEXT, BYTEA) can optimize memory alignment, reduce padding, and improve performance. Topics such as storage efficiency, faster sequential scans, index optimization, and data export compatibility will be discussed. However, the talk will also address the limitations of this optimization, including its reduced impact on modern performance, flexibility, readability, and maintainability, concluding with practical takeaways.