| From: | Aleksander Alekseev <aleksander(at)tigerdata(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | M(dot)Atıf Ceylan <mehmet(at)atifceylan(dot)com> |
| Subject: | Re: [PATCH] psql: add size-based sorting options (O/o) for tables and indexes |
| Date: | 2025-11-26 13:40:32 |
| Message-ID: | CAJ7c6TNfSw6kgZuPK7=Br9ip=AYwHMT0aHDPPxfV+FL8rxUAmQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
> This patch adds two new meta-command modifiers for \dt(+) and \di(+):
>
> -O : sort by total relation size descending
> -o : sort by total relation size ascending
>
> This makes it easier to identify the largest tables and indexes
> without writing custom SQL queries.
>
> Help message (\?) is updated to reflect the new options.
Thanks for the patch. I have no strong opinion on whether this is a
valuable change but if you are adding new code it needs tests. The
corresponding documentation section should be changed as well [1].
Please re-submit the updated version of the patch as an attachment
created with `git format-patch` and add it to the nearest open
commitfest [2].
[1]: https://www.postgresql.org/docs/current/app-psql.html
[2]: https://commitfest.postgresql.org/
--
Best regards,
Aleksander Alekseev
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nazir Bilal Yavuz | 2025-11-26 13:44:00 | macOS - Sequoia CI task is stuck on the Postgres Github CI |
| Previous Message | Laurenz Albe | 2025-11-26 13:28:06 | Re: System views for versions reporting |