From: Tom Lane <tgl@sss.pgh.pa.us>
To: John Mendenhall <john@surfutopia.net>
Cc: pgsql-performance list <pgsql-performance@postgresql.org>
Subject: Re: complex query performance assistance request
Date: Mon, 22 Aug 2005 20:54:30 -0400
Message-ID: <26869.1124758470@sss.pgh.pa.us> (raw)
In-Reply-To: <20050822210751.GA32479@calvin.surfutopia.net>
References: <20050821034841.GA28968@calvin.surfutopia.net>
<20050822182138.GA30818@calvin.surfutopia.net>
<20830.1124741718@sss.pgh.pa.us>
<20050822210751.GA32479@calvin.surfutopia.net>
John Mendenhall <john@surfutopia.net> writes:
> Would it be best to attempt to rewrite it for IN?
> Or, should we try to tie it in with a join?
Couldn't say without a deeper understanding of what you're trying to
accomplish.
> BTW, what does the Materialize query plan element mean?
Means "run the contained subplan once, and save the results aside in a
buffer; on subsequent loops, just pass back the buffer contents instead
of re-running the subplan".
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, john@surfutopia.net
Subject: Re: complex query performance assistance request
In-Reply-To: <26869.1124758470@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