| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Justin Pryzby <pryzby(at)telsasoft(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: relkind='p' has no pg_stat_user_tables |
| Date: | 2018-05-03 16:20:47 |
| Message-ID: | 20180503162047.37k7km4dx62i6l4d@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adrian Klaver wrote:
> and from here:
>
> https://www.postgresql.org/docs/10/static/sql-createtable.html
>
> "A partitioned table is divided into sub-tables (called partitions), which
> are created using separate CREATE TABLE commands. The partitioned table is
> itself empty. A data row inserted into the table is routed to a partition
> based on the value of columns or expressions in the partition key. ... "
Yeah, but I think Justin has a valid question from the POV of the user:
how can we figure out if we need to re-run analyze on a partitioned
table, if the time of last analyze is not stored anywhere?
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-05-03 16:31:12 | Re: relkind='p' has no pg_stat_user_tables |
| Previous Message | Adrian Klaver | 2018-05-03 16:18:20 | Re: relkind='p' has no pg_stat_user_tables |