Re: make \d pg_toast.foo show its indices ; and, \d toast show its main table ; and \d relkind=I show its partitions

From:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
To:	Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc:	Rafia Sabih <rafia(dot)pghackers(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: make \d pg_toast.foo show its indices ; and, \d toast show its main table ; and \d relkind=I show its partitions
Date:	2019-07-17 06:26:34
Message-ID:	20190717062634.GV22387@telsasoft.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2019-04-22 15:49:02 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎  2019-05-03 12:55:47 from Rafia Sabih <rafia(dot)pghackers(at)gmail(dot)com>   2019-05-03 14:27:22 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎    2019-05-06 07:13:52 from Rafia Sabih <rafia(dot)pghackers(at)gmail(dot)com>     2019-05-06 15:58:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2019-05-06 16:26:31 from Andres Freund <andres(at)anarazel(dot)de>       2019-05-06 17:52:23 from Robert Haas <robertmhaas(at)gmail(dot)com>      2019-05-07 15:16:00 from Stephen Frost <sfrost(at)snowman(dot)net>       2019-05-07 15:24:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2019-05-07 15:30:06 from Stephen Frost <sfrost(at)snowman(dot)net>         2019-05-07 20:44:53 from Robert Haas <robertmhaas(at)gmail(dot)com>          2019-05-07 20:48:09 from Stephen Frost <sfrost(at)snowman(dot)net>           2019-05-07 21:49:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2019-05-07 22:03:29 from Stephen Frost <sfrost(at)snowman(dot)net>             2019-05-08 14:18:13 from Robert Haas <robertmhaas(at)gmail(dot)com>              2019-05-08 14:28:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2019-05-06 16:22:51 from Justin Pryzby <pryzby(at)telsasoft(dot)com>      2019-05-06 16:33:59 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>      2019-06-23 14:25:47 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎       2019-06-27 23:02:02 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎        2019-06-30 08:26:28 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>         2019-07-16 05:01:24 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎          2019-07-16 14:06:36 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎           2019-07-17 06:26:34 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎            2019-07-23 07:19:00 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>             2019-07-23 21:08:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2019-07-23 22:06:58 from Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v7-0001-print-table-associated-with-given-TOAST-table.patch	text/x-diff	2.4 KB
v7-0002-make-d-pg_toast.foo-show-its-indices.patch	text/x-diff	1.3 KB
v7-0003-show-childs-of-partitioned-indices.patch	text/x-diff	13.9 KB

In response to

• Re: make \d pg_toast.foo show its indices ; and, \d toast show its main table ; and \d relkind=I show its partitions at 2019-07-16 14:06:36 from Justin Pryzby

Responses

• Re: make \d pg_toast.foo show its indices ; and, \d toast show its main table ; and \d relkind=I show its partitions at 2019-07-23 07:19:00 from Fabien COELHO

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Amit Kapila	2019-07-17 06:27:43	Re: POC: Cleaning up orphaned files using undo logs
Previous Message	Amit Kapila	2019-07-17 06:12:52	Re: POC: Cleaning up orphaned files using undo logs