Re: partition tree inspection functions

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: partition tree inspection functions
Дата
Msg-id 20181001062743.GA11712@paquier.xyz
обсуждение исходный текст
Ответ на Re: partition tree inspection functions  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Ответы Re: partition tree inspection functions
Список pgsql-hackers
On Mon, Oct 01, 2018 at 03:16:32PM +0900, Amit Langote wrote:
> I wasn't able to respond to some of issues that Jesper brought up with the
> approach taken by the latest patch whereby there is no separate
> pg_partition_level function.  He said that such a function would be useful
> to get the information about the individual leaf partitions, but I was no
> longer sure of providing such a function separately.

Perhaps that could be debated separately as well?  From what I can see
what's available would unlock the psql patch which would like to add
support for \dP, or show the size of partitions more easily.  I am also
not completely sure that I see the use-case for pg_partition_level or
even pg_partition_root_parent as usually in their schemas users append
rather similar relation names to the parent and the children.  Or
perhaps not?
--
Michael

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: libpq should append auth failures, not overwrite
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Sample values for pg_stat_statements