Postgres Pro
Downloads
Home   >   mailing lists

Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)? - Mailing list pgsql-novice

From David Rowley
Subject Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?
Date
Msg-id CAKJS1f_DxmRLRP+oG_+Wc8GoKWW8w3O0e_7ANhpdDR9XYSaWtg@mail.gmail.com
Whole thread Raw
In response to Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses RE: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?
List pgsql-novice
Tree view 
On 20 January 2018 at 18:50, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Stephen Froehlich <s.froehlich@cablelabs.com> writes:
>> Are custom statistics in PG10 retained in LIKE (INCLUDING ALL) or do I need to recreate the statistics by hand each
timeI 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?
Next
From: Stephen Froehlich
Date:
Subject: RE: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?