Postgres Pro
Downloads
Home   >   mailing lists

Re: what does "initplan" operation in explain output mean? - Mailing list pgsql-performance

From Tom Lane
Subject Re: what does "initplan" operation in explain output mean?
Date
Msg-id 20342.1280770187@sss.pgh.pa.us
Whole thread Raw
In response to Re: what does "initplan" operation in explain output mean?  (Mark Rostron <mrostron@ql2.com>)
List pgsql-performance
Tree view 
Mark Rostron <mrostron@ql2.com> writes:
> So am I right in assuming that the aggregate sub-query ( against work_active ) results will not assist with
constraintexclusion in the sub-query against work_unit (if we introduce range partitions on this table)? 

Dunno.  You didn't actually show what you were hoping would work, or
work differently as the case may be.

            regards, tom lane

pgsql-performance by date:

Previous
From: Mark Rostron
Date:
Subject: Re: what does "initplan" operation in explain output mean?
Next
From: Maciek Sakrejda
Date:
Subject: Optimizing NOT IN plans / verify rewrite