Re: make \d pg_toast.foo show its indices

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: make \d pg_toast.foo show its indices
Дата
Msg-id CA+TgmoZ8YdV4oJ49obi1au_Jn5TgH8pTGvyS+dHkMjYxG8ZgrA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: make \d pg_toast.foo show its indices  (Andres Freund <andres@anarazel.de>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Unhappy about API changes in the no-fsm-for-small-rels patch
Следующее
От: Bruce Momjian
Дата:
Сообщение: Naming of pg_checksums