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

From Andres Freund
Subject Re: make \d pg_toast.foo show its indices
Date
Msg-id 20190506162631.pjn3h5ppsbig4mx7@alap3.anarazel.de
Whole thread Raw
In response to Re: make \d pg_toast.foo show its indices  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: make \d pg_toast.foo show its indices  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Hi,

On 2019-05-06 11:58:18 -0400, Tom Lane wrote:
> Not sure though --- generally, if you're looking at a specific
> toast table, you already know which table is its parent.  But
> maybe confirmation is a good thing.

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.


> 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

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table
Next
From: Alvaro Herrera
Date:
Subject: Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table