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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Froehlich <s(dot)froehlich(at)cablelabs(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?
Date: 2018-01-20 05:50:19
Message-ID: 24425.1516427419@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-novice

Stephen Froehlich <s(dot)froehlich(at)cablelabs(dot)com> 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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2018-01-20 06:01:20 Re: Test-cases for exclusion constraints is missing in alter_table.sql file
Previous Message Amit Kapila 2018-01-20 05:29:24 Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation)

Browse pgsql-novice by date

  From Date Subject
Next Message David Rowley 2018-01-21 06:21:52 Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?
Previous Message Stephen Froehlich 2018-01-19 05:23:26 STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?