Re: [PATCH] psql: add size-based sorting options (O/o) for tables and indexes

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

In response to

Browse pgsql-hackers by date

  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