Horton

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

David Rowley <david.rowley@2ndquadrant.com>

View thread View on postgr.es
From: David Rowley <david.rowley@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Stephen Froehlich <s.froehlich@cablelabs.com>, "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
Date: 2018-01-21T06:21:52Z
Lists: pgsql-hackers, pgsql-novice 
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 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

Commits

  1. Clone extended stats in CREATE TABLE (LIKE INCLUDING ALL)

  2. Identity columns