STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?

Поиск
Список
Период
Сортировка
От Stephen Froehlich
Тема STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?
Дата
Msg-id CY1PR0601MB1927315B45667A1B679D0FD5E5EF0@CY1PR0601MB1927.namprd06.prod.outlook.com
обсуждение исходный текст
Ответы Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?
Список pgsql-novice

I use a CREATE TABLE … LIKE [default_table] (INCLUDING ALL) query to create partitions of a hypertable, and I have found that I need to add a “CREATE STATISTICS” entry between two columns of the table.

 

Are custom statistics in PG10 retained in LIKE (INCLUDING ALL) or do I need to recreate the statistics by hand each time I create a new table?

 

Thanks,

Stephen

 

Stephen Froehlich
Sr. Strategist, CableLabs®


s.froehlich@cablelabs.com

Tel: +1 (303) 661-3708

 

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

Предыдущее
От: Garry Chen
Дата:
Сообщение: RE: how to remove set_config from all user
Следующее
От: Tom Lane
Дата:
Сообщение: Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?