From: Kenneth Marshall <ktm@rice.edu>
To: Kevin Kempter <kevink@consistentstate.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: prepared statements and partitioning (partition elimination not working)
Date: Mon, 8 Mar 2010 11:31:43 -0600
Message-ID: <20100308173143.GD19562@it.is.rice.edu> (raw)
In-Reply-To: <201003081024.56840.kevink@consistentstate.com>
References: <201003081024.56840.kevink@consistentstate.com>
On Mon, Mar 08, 2010 at 10:24:56AM -0700, Kevin Kempter wrote:
> Hi all;
>
> we've found that partition elimination is not happening for a prepared
> statement, however running the same statement in psql manually does give us
> partition elimination.
>
> Is this a known issue?
>
Yes, see the recent threads on performance of prepared queries.
It concerns the availability of information on the query inputs
that is available to psql and not a pre-prepared query.
Cheers,
Ken
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: ktm@rice.edu, kevink@consistentstate.com
Subject: Re: prepared statements and partitioning (partition elimination not working)
In-Reply-To: <20100308173143.GD19562@it.is.rice.edu>
* 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