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

Поиск
Список
Период
Сортировка
Искать
От
David Rowley
Тема
Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?
Дата
Msg-id
CAKJS1f_DxmRLRP+oG_+Wc8GoKWW8w3O0e_7ANhpdDR9XYSaWtg@mail.gmail.com
Ответ на
Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)? (Tom Lane)
Список
Дерево обсуждения
STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)? Stephen Froehlich <s.froehlich@cablelabs.com>
Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)? Tom Lane <tgl@sss.pgh.pa.us>
Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)? David Rowley <david.rowley@2ndquadrant.com>
RE: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)? Stephen Froehlich <s.froehlich@cablelabs.com> 
On 20 January 2018 at 18:50, Tom Lane  wrote:
> Stephen Froehlich  writes:
>> 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?
>
> LIKE doesn't know about those, no.  Perhaps it should.

Agreed. ALL does not mean MOST.


-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-novice по дате отправления
Предыдущее
От: Tom Lane
Дата:
Следующее
От: Stephen Froehlich
Дата:
FAQ