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

From: Stephen Froehlich <s(dot)froehlich(at)cablelabs(dot)com>
To: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-21 15:47:35
Message-ID: CY1PR0601MB1927F8282656E5544FBE0FBAE5ED0@CY1PR0601MB1927.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-novice

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

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

On 20 January 2018 at 18:50, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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.

Agreed. ALL does not mean MOST.

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-01-21 16:02:29 Re: [HACKERS] Refactor handling of database attributes between pg_dump and pg_dumpall
Previous Message Bruce Momjian 2018-01-21 15:17:48 Re: [HACKERS] Refactor handling of database attributes between pg_dump and pg_dumpall

Browse pgsql-novice by date

  From Date Subject
Next Message ferraresso@tin.it 2018-01-22 08:45:44 create subscription, connection string, password in log not hide
Previous Message David Rowley 2018-01-21 06:21:52 Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?