Re: what does "initplan" operation in explain output mean?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Rostron <mrostron(at)ql2(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: what does "initplan" operation in explain output mean?
Date: 2010-08-02 17:29:47
Message-ID: 20342.1280770187@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mark Rostron <mrostron(at)ql2(dot)com> writes:
> So am I right in assuming that the aggregate sub-query ( against work_active ) results will not assist with constraint exclusion 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Maciek Sakrejda 2010-08-02 19:12:51 Optimizing NOT IN plans / verify rewrite
Previous Message Mark Rostron 2010-08-02 16:42:45 Re: what does "initplan" operation in explain output mean?