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

[Stephen Froehlich]

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(r)

***@cablelabs.com
Tel: [phone]

[Tom Lane]

Post by Stephen Froehlich
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.

regards, tom lane

[David Rowley]

Post by Tom Lane

Post by Stephen Froehlich
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.

[Stephen Froehlich]

Lol ... However sometimes, especially with an obscure new feature, it does :).

-----Original Message-----
From: David Rowley [mailto:***@2ndquadrant.com]
Sent: Saturday, January 20, 2018 11:22 PM
To: Tom Lane <***@sss.pgh.pa.us>
Cc: Stephen Froehlich <***@cablelabs.com>; pgsql-***@postgresql.org
Subject: Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?

Post by Tom Lane

Post by Stephen Froehlich
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 Dev