Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?
Date
Msg-id 24425.1516427419@sss.pgh.pa.us
Whole thread Raw
In response to STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?  (Stephen Froehlich <s.froehlich@cablelabs.com>)
Responses Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?
List pgsql-novice
Tree view 
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.

            regards, tom lane

pgsql-novice by date:

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