Re: proposal - psql - show longest tables - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal - psql - show longest tables
Date
Msg-id CAFj8pRDaP1H=5G2HkDFYk4YQpmxbiUTQK5BxktU0YLrpo7Qjew@mail.gmail.com
Whole thread Raw
In response to Re: proposal - psql - show longest tables  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
>> I agree with Robert. My tip is this: when you're in a hole, the first thing
>> to do is to stop digging.
>
> I don't think that Pavel believes himself to be in a hole.
>
> After setting up my .psqlrc file as I normally do, I could do this:
>
> :rtsize limit 10;
>
> But it doesn't have the 'MB' feature, and if I want to help someone
> else I first have to explain to them how to set their .psqlrc file the
> same as mine, which is rather a bummer.
>
> Is looking for the biggest tables a common enough thing that it should
> be available to everyone, without needing custom customization?

I am thinking so our psql interface is not complete without this
feature in this are. But, sure, it is my opinion only.

Everybody know command \dt and then should to learn only one char more
"s" or "r".

In this time, we use (in GoodData) patch, that change order for \dt+
from alphabet to size ordered. But it is too limited.

Regards

Pavel


>
> Cheers,
>
> Jeff



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Auto explain target tables
Next
From: Greg Smith
Date:
Subject: Re: [9.4 CF 1] And then there were 5