Re: ToDo: show size of partitioned table
От
Michael Paquier
Тема
Re: ToDo: show size of partitioned table
Дата
Msg-id
20181122142911.GA12620@paquier.xyz
Ответ на
Re: ToDo: show size of partitioned table (Pavel Stehule)
Список
Дерево обсуждения
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
Дата: