Presented by:

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.

Date:
2025 March 7 - 12:15
Duration:
45 min
Room:
Grand Ballroom 1
Conference:
PGConf India, 2025
Language:
Track:
Database Administration
Difficulty:
Medium

Happening at the same time:

  1. Enhancing Security in PostgreSQL: Key Changes from Version 10 to 17
  2. Start Time:
    2025 March 7 12:15

    Room:
    Jupiter

  3. Reliability features in Postgres Pro: BiHA, load balancing and backups
  4. Start Time:
    2025 March 7 12:15

    Room:
    Neptune

  5. Things your explain plan is not telling you
  6. Start Time:
    2025 March 7 12:15

    Room:
    Grand Ballroom 2