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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
