Re: query optimization on prepared statement through - Mailing list pgsql-interfaces

From Jeroen T. Vermeulen
Subject Re: query optimization on prepared statement through
Date
Msg-id 11196.125.24.218.106.1165291555.squirrel@webmail.xs4all.nl
Whole thread Raw
In response to Re: query optimization on prepared statement through  (Keary Suska <hierophant@pcisys.net>)
List pgsql-interfaces
On Tue, December 5, 2006 00:25, Keary Suska wrote:

> Note that even if queries use an updated query plan, the planner may not
> choose the best plan anyway. There are various parameters that may effect
> the planner, such as inferred types and joins across different (although
> compatible) column types. This last bit may have been solved recently,
> however.

Also, IIRC it's possible to create indexes on function results.  So if you
have, say, an integer column X then you could possibly index that table on
"X converted to text."


Jeroen




pgsql-interfaces by date:

Previous
From: Keary Suska
Date:
Subject: Re: query optimization on prepared statement through
Next
From: "Fayza Sultan"
Date:
Subject: Unable to Install on Windows (using MINGW) with PL/TCL and PL/Perl libraries support