From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mark Rostron <mrostron@ql2.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: what does "initplan" operation in explain output mean?
Date: Mon, 02 Aug 2010 13:29:47 -0400
Message-ID: <20342.1280770187@sss.pgh.pa.us> (raw)
In-Reply-To: <FD020D3E50E7FA479567872E5F5F31E30459D62323@ex01.corp.ql2.com>
References: <FD020D3E50E7FA479567872E5F5F31E30459D622B0@ex01.corp.ql2.com>
<4572.1280671706@sss.pgh.pa.us>
<FD020D3E50E7FA479567872E5F5F31E30459D62323@ex01.corp.ql2.com>
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 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, mrostron@ql2.com
Subject: Re: what does "initplan" operation in explain output mean?
In-Reply-To: <20342.1280770187@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox