From: Jeroen T. Vermeulen <jtv@xs4all.nl>
To: Keary Suska <hierophant@pcisys.net>
Cc: Postgres-Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: query optimization on prepared statement through
Date: Tue, 5 Dec 2006 11:05:55 +0700 (ICT)
Message-ID: <11196.125.24.218.106.1165291555.squirrel@webmail.xs4all.nl> (raw)
In-Reply-To: <C199A808.919C%hierophant@pcisys.net>
References: <C199A808.919C%hierophant@pcisys.net>
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
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-interfaces@postgresql.org
Cc: jtv@xs4all.nl, hierophant@pcisys.net
Subject: Re: query optimization on prepared statement through
In-Reply-To: <11196.125.24.218.106.1165291555.squirrel@webmail.xs4all.nl>
* 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