Hacker GitHub

← All repos

NikolayS/postgres_dba

View on GitHub ↗ ★ 1,297 PLpgSQL

The missing set of useful tools for Postgres DBAs and all engineers

4 mentions on Hacker News by 4 people: 0 stories, 4 comments · first 2018-03-01 · latest 2024-10-07

Mentions per year 4 mentions · busiest year 2024 (2)
20082026
AllStoriesComments NewestTopOldest
  1. The ever-useful postgres_dba tool ( 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.
    comment by gnfargbl · 2024-10-07 · in Optimizing Postgres table layout for maximum efficiency
  2. This is even handier: https://github.com/NikolayS/postgres_dba
    comment by lomereiter · 2024-06-12 · in How to get the most out of Postgres memory settings
  3. In a similar vein, I got good value from these scripts: https://github.com/NikolayS/postgres_dba I managed to free 10% a.k.a about 100 GB of storage by reorganizing table column ordering in a big table.
    comment by hyperman1 · 2023-08-28 · in An unexpected find that freed 20GB of unused index space (2021)
  4. This is one of the interesting optimizations that DBMS should do automatically but it doesn't. https://github.com/NikolayS/postgres_dba -- this toolset includes a version of report (see report a1) which analyses all tables in your database…
    comment by postila · 2018-03-01 · in “Column Tetris” – Calculating and Saving Space in PostgreSQL