Re: make \d pg_toast.foo show its indices - Mailing list pgsql-hackers

From Robert Haas
Subject Re: make \d pg_toast.foo show its indices
Date
Msg-id CA+TgmoZ8YdV4oJ49obi1au_Jn5TgH8pTGvyS+dHkMjYxG8ZgrA@mail.gmail.com
Whole thread Raw
In response to Re: make \d pg_toast.foo show its indices  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Mon, May 6, 2019 at 12:26 PM Andres Freund <andres@anarazel.de> wrote:
> I'm not convinced by that. I've certainly many a time wrote queries
> against pg_class to figure out which relation a toast table belongs
> to. E.g. after looking at the largest relations in the system, looking
> at pg_stat_*_tables, after seeing an error in the logs, etc.

+1.  I think it would be great for \d on the TOAST table to show this
information.

> > That seems off-topic for this thread though.  I agree with the
> > stated premise that \d on a toast table should show all the same
> > information \d on a regular table would.
>
> +1

That premise seems like a good one, too.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Unhappy about API changes in the no-fsm-for-small-rels patch
Next
From: Bruce Momjian
Date:
Subject: Naming of pg_checksums