Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table
Дата
в 16:33:59
Msg-id
20190506163359.GA29291@alvherre.pgsql
Ответ на
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table (Justin Pryzby)
Список
Дерево обсуждения
make \d pg_toast.foo show its indices Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices Rafia Sabih <rafia.pghackers@gmail.com>
Re: make \d pg_toast.foo show its indices Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices Rafia Sabih <rafia.pghackers@gmail.com>
Re: make \d pg_toast.foo show its indices Tom Lane <tgl@sss.pgh.pa.us>
Re: make \d pg_toast.foo show its indices Andres Freund <andres@anarazel.de>
Re: make \d pg_toast.foo show its indices Robert Haas <robertmhaas@gmail.com>
Re: make \d pg_toast.foo show its indices Stephen Frost <sfrost@snowman.net>
Re: make \d pg_toast.foo show its indices Tom Lane <tgl@sss.pgh.pa.us>
Re: make \d pg_toast.foo show its indices Stephen Frost <sfrost@snowman.net>
Re: make \d pg_toast.foo show its indices Robert Haas <robertmhaas@gmail.com>
Re: make \d pg_toast.foo show its indices Stephen Frost <sfrost@snowman.net>
Re: make \d pg_toast.foo show its indices Tom Lane <tgl@sss.pgh.pa.us>
Re: make \d pg_toast.foo show its indices Stephen Frost <sfrost@snowman.net>
Re: make \d pg_toast.foo show its indices Robert Haas <robertmhaas@gmail.com>
Re: make \d pg_toast.foo show its indices Tom Lane <tgl@sss.pgh.pa.us>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table Alvaro Herrera <alvherre@2ndquadrant.com> 
On 2019-May-06, Justin Pryzby wrote:

> Perhaps ... but TOAST is an implementation detail, and I think it should rarely
> be important to know the toast table for a given table.

I'm with Andres -- while it's admittedly a rare need, it is a real one.

Sometimes I wish for \d++ which would display internal details too obscure
to show in the regular \d+, such as the toast table name.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления
Предыдущее
От: Andres Freund
Дата:
Следующее
От: Jonathan S. Katz
Дата:
FAQ