Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions (and tablespace)
От
Justin Pryzby
Тема
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions (and tablespace)
Дата
Msg-id
20190623142546.GE16019@telsasoft.com
Ответ на
Список
Дерево обсуждения
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>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions (and tablespace) Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions (and tablespace) Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions (and tablespace) Fabien COELHO <coelho@cri.ensmp.fr>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions (and tablespace) Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions Fabien COELHO <coelho@cri.ensmp.fr>
Re: make \d pg_toast.foo show its indices ; and, \d toast show its main table ; and \d relkind=I show its partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions Fabien COELHO <coelho@cri.ensmp.fr>
I'm continuing this thread with an additional change to slash dee for
partitioned indexes.
postgres=# \d ttz_i_idx
Partitioned index "public.ttz_i_idx"
Column | Type | Key? | Definition
--------+---------+------+------------
i | integer | yes | i
btree, for table "public.ttz"
Number of partitions: 2 (Use \d+ to list them.)
postgres=# \d+ ttz_i_idx
Partitioned index "public.ttz_i_idx"
Column | Type | Key? | Definition | Storage | Stats target
--------+---------+------+------------+---------+--------------
i | integer | yes | i | plain |
btree, for table "public.ttz"
Partitions: ttz1_i_idx,
ttz2_i_idx, PARTITIONED
Showing the list of index partitions is probably not frequently useful, but
consider the case of non-default names, for example due to truncation.
I didn't update regression output; note that this patch also, by chance, causes
tablespace of partitioned indexes to be output, which I think is good and an
oversight that it isn't currently shown.
I added CF entry and including previous two patches for CFBOT purposes.
Recap: Tom, Andreas, Robert, Stephen and I agree that \d toast should show the
main table. Rafia and Alvaro think that \d on the main table should (also?)
show its toast.
Justin
В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата: