4 ms·

The ever-useful postgres_dba tool (https://github.com/NikolayS/postgres_dba https://github.com/NikolayS/postgres_dba) can help with this. Install it, start psql

The ever-useful postgres_dba tool (https://github.com/NikolayS/postgres_dba https://github.com/NikolayS/postgres_dba) can help with this. Install it, start psql, run :dba and choose option p1 to see how much table space you would save by reordering your columns.

samokhvalov 2y ago
Thanks for mentioning!
- gnfargbl 2y ago
  Thanks for the tool! It has helped me out of the mire more than once.
- fforflo 2y ago
  Looked nice so I automatically did git clone && cd postgres_dba && make all install installcheck... and failed :D Creatures of habit... any plans to make this an extension?