Re: ToDo: show size of partitioned table

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: ToDo: show size of partitioned table
Дата
Msg-id
20181122142911.GA12620@paquier.xyz
Ответ на
Список
Дерево обсуждения
ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Michael Paquier <michael@paquier.xyz>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Michael Paquier <michael@paquier.xyz>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Michael Paquier <michael@paquier.xyz>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Mathias Brossard <postgresql@zoinx.org>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Mathias Brossard <mathias@brossard.org>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Michael Paquier <michael@paquier.xyz>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Michael Paquier <michael@paquier.xyz>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Michael Paquier <michael@paquier.xyz>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Michael Paquier <michael@paquier.xyz>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Michael Paquier <michael@paquier.xyz>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Michael Paquier <michael@paquier.xyz>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Michael Paquier <michael@paquier.xyz>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Justin Pryzby <pryzby@telsasoft.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Justin Pryzby <pryzby@telsasoft.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Justin Pryzby <pryzby@telsasoft.com>
Re: ToDo: show size of partitioned table Justin Pryzby <pryzby@telsasoft.com>
Re: ToDo: show size of partitioned table Justin Pryzby <pryzby@telsasoft.com>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Re: ToDo: show size of partitioned table David Steele <david@pgmasters.net>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: ToDo: show size of partitioned table Amit Langote <amitlangote09@gmail.com>
Re: ToDo: show size of partitioned table Michael Paquier <michael@paquier.xyz>
Re: ToDo: show size of partitioned table Pavel Stehule <pavel.stehule@gmail.com>
Re: ToDo: show size of partitioned table Jeevan Ladhe <jeevan.ladhe@enterprisedb.com>
On Thu, Nov 22, 2018 at 12:42:14PM +0100, Pavel Stehule wrote:
> Here my position is strong. \dP for me doesn't mean "tables or
> indexes" - it means "partition tables with total relation size". I
> don't see any sense to show tables and indexes in one report.

Please let me disagree on that point.  \dP, \dPt and \dPi are commands
able to show information about respectively partitioned relations,
partitioned tables and partitioned indexes, which is not something only
related to the size of those partitions.  Showing only the level of a
relation in its hierarchy may be useful, but that's confusing for the
user without knowing its direct parent or its top-most parent.  For
multiple levels, the direct parent without the number in the hierarchy
seems enough to me.  I may be of course wrong in designing those
concepts.
--
Michael
В списке pgsql-hackers по дате отправления
От: Amit Kapila
Дата:
От: Pavel Stehule
Дата:
FAQ