Feedback-ID: i0c21471d:Fastmail
MIME-Version: 1.0
Date: Wed, 26 Nov 2025 09:43:38 -0300
From: "Euler Taveira" <euler@eulerto.com>
To: =?UTF-8?Q?M=2EAt=C4=B1f_Ceylan?= <mehmet@atifceylan.com>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
Message-Id: <84647ed5-9302-4c1e-8364-6c575cee20b0@app.fastmail.com>
In-Reply-To: 
 <CA+M9mDThhJmuzN8umoPx2JhhKWkXpKO_1E3+4MCSdqE9SnmCjw@mail.gmail.com>
References: 
 <CA+M9mDThhJmuzN8umoPx2JhhKWkXpKO_1E3+4MCSdqE9SnmCjw@mail.gmail.com>
Subject: Re: [PATCH] psql: add size-based sorting options (O/o) for tables and
 indexes
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/84647ed5-9302-4c1e-8364-6c575cee20b0%40app.fastmail.com>
Precedence: bulk

On Wed, Nov 26, 2025, at 4:48 AM, M.At=C4=B1f Ceylan wrote:
> Hello,
> 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
>

Thanks for your contribution. Register your patch in the next commitfest=
 [1] so
we don't loose track of it.

I didn't look at your patch but I was wondering if a general solution is=
n't a
better way to add this feature. I wouldn't modify these specific psql
meta-commands, instead, I would add a new psql meta-command that defines=
 this
property for all objects if applicable.

\sort [ name | size [ asc | desc ] ]

I thought about a list to be cover other sort cases too but if things st=
arting
to be complex, it is time to write your own query.

With a parameter, it appends the ORDER BY clause in the SQL commands exe=
cuted by
psql if applicable. Without a parameter, it uses the current behavior.


[1] https://commitfest.postgresql.org/57/


--=20
Euler Taveira
EDB   https://www.enterprisedb.com/