SQLite Forum

Column ordering and space saving
Login
I've been reading a few articles regarding PostgreSQL about re-ordering columns in order to save space, for example:

* <https://www.2ndquadrant.com/en/blog/on-rocks-and-sand/>
* <https://docs.gitlab.com/ee/development/ordering_table_columns.html>

However, the [SQLite type system](https://sqlite.org/datatype3.html) is different, which may make the considerations above unapplicable. 

So I'm wondering if there would be any space saving by re-ordering columns, is there any sort of padding/alignment in SQLite, or is the record packed with no spaces between columns?

Cheers
Andrea

*Edit by drh to activate hyperlinks*