Re: relkind='p' has no pg_stat_user_tables

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: relkind='p' has no pg_stat_user_tables
Дата
Msg-id 20180503162047.37k7km4dx62i6l4d@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: relkind='p' has no pg_stat_user_tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: relkind='p' has no pg_stat_user_tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Adrian Klaver wrote:

> and from here:
> 
> https://www.postgresql.org/docs/10/static/sql-createtable.html
> 
> "A partitioned table is divided into sub-tables (called partitions), which
> are created using separate CREATE TABLE commands. The partitioned table is
> itself empty. A data row inserted into the table is routed to a partition
> based on the value of columns or expressions in the partition key. ... "

Yeah, but I think Justin has a valid question from the POV of the user:
how can we figure out if we need to re-run analyze on a partitioned
table, if the time of last analyze is not stored anywhere?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: relkind='p' has no pg_stat_user_tables
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: relkind='p' has no pg_stat_user_tables