pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedprepared statements and partitioning (partition elimination not working)
2+ messages / 2 participants
[nested] [flat]
* prepared statements and partitioning (partition elimination not working)
@ 2010-03-08 17:24 Kevin Kempter <kevink@consistentstate.com>
2010-03-08 17:31 ` Re: prepared statements and partitioning (partition elimination not working) Kenneth Marshall <ktm@rice.edu>
0 siblings, 1 reply; 2+ messages in thread
From: Kevin Kempter @ 2010-03-08 17:24 UTC (permalink / raw)
To: pgsql-performance
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?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: prepared statements and partitioning (partition elimination not working)
2010-03-08 17:24 prepared statements and partitioning (partition elimination not working) Kevin Kempter <kevink@consistentstate.com>
@ 2010-03-08 17:31 ` Kenneth Marshall <ktm@rice.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Kenneth Marshall @ 2010-03-08 17:31 UTC (permalink / raw)
To: Kevin Kempter <kevink@consistentstate.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-03-08 17:31 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-08 17:24 prepared statements and partitioning (partition elimination not working) Kevin Kempter <kevink@consistentstate.com>
2010-03-08 17:31 ` Kenneth Marshall <ktm@rice.edu>
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