Обсуждение: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?

Поиск
Список
Период
Сортировка

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®


s.froehlich@cablelabs.com

Tel: +1 (303) 661-3708

 

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

От
Tom Lane
Дата:
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

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

От
David Rowley
Дата:
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
timeI 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

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

От
Stephen Froehlich
Дата:
Lol ... However sometimes, especially with an obscure new feature, it does :).

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

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
timeI 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