On Thu, May 03, 2018 at 01:24:59PM -0500, Justin Pryzby wrote:
> Yes, I was surprised about the difference between ANALYZE relkind_p
> and relkind_r.
>
> But I see that's a documented behavior I'd missed until now:
>
> https://www.postgresql.org/docs/current/static/sql-analyze.html
> |If the spec
On Thu, May 03, 2018 at 11:15:19AM -0700, Adrian Klaver wrote:
> On 05/03/2018 10:38 AM, Justin Pryzby wrote:
> >On Thu, May 03, 2018 at 09:31:12AM -0700, Adrian Klaver wrote:
> >>On 05/03/2018 09:20 AM, Alvaro Herrera wrote:
> https://www.postgresql.org/docs/10/static/sql-createtable.html
> >>
On 05/03/2018 10:38 AM, Justin Pryzby wrote:
On Thu, May 03, 2018 at 09:31:12AM -0700, Adrian Klaver wrote:
On 05/03/2018 09:20 AM, Alvaro Herrera wrote:
https://www.postgresql.org/docs/10/static/sql-createtable.html
"A partitioned table is divided into sub-tables (called partitions), which
ar
On Thu, May 03, 2018 at 09:31:12AM -0700, Adrian Klaver wrote:
> On 05/03/2018 09:20 AM, Alvaro Herrera wrote:
> >>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
On 05/03/2018 09:20 AM, Alvaro Herrera wrote:
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 i
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
On 05/03/2018 08:45 AM, Justin Pryzby wrote:
On Thu, May 03, 2018 at 07:44:24AM -0700, Adrian Klaver wrote:
On 05/03/2018 07:14 AM, Justin Pryzby wrote:
I (finally) realized that my script for ANALYZEing parents of table hierarchies
every month or so was looping around the same parent tables ev
On Thu, May 03, 2018 at 07:44:24AM -0700, Adrian Klaver wrote:
> On 05/03/2018 07:14 AM, Justin Pryzby wrote:
> >I (finally) realized that my script for ANALYZEing parents of table
> >hierarchies
> >every month or so was looping around the same parent tables every night due
> >to
> >no stats for
On 05/03/2018 07:14 AM, Justin Pryzby wrote:
I (finally) realized that my script for ANALYZEing parents of table hierarchies
every month or so was looping around the same parent tables every night due to
no stats for date of last last analysis.
Would help to see the script.
I guess that's de
