From: Pierre C <lists@peufeu.com>
To: Joel Jacobson <joel@gluefinance.com>
To: pgsql-performance@postgresql.org
Subject: Re: plpgsql plan cache
Date: Mon, 22 Feb 2010 20:42:44 +0100
Message-ID: <op.u8jnpjikeorkce@localhost> (raw)
In-Reply-To: <38E2265E-B38E-4EBD-BB87-23B46EF4FD1C@gluefinance.com>
References: <38E2265E-B38E-4EBD-BB87-23B46EF4FD1C@gluefinance.com>
> I cannot understand why the index is not being used when in the plpgsql
> function?
> I even tried to make a test function containing nothing more than the
> single query. Still the index is not being used.
> When running the same query in the sql prompt, the index is in use
> though.
Please post the following :
- EXPLAIN ANALYZE your query directly in psql
- PREPARE testq AS your query
- EXPLAIN ANALYZE EXECUTE testq( your parameters )
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: lists@peufeu.com, joel@gluefinance.com
Subject: Re: plpgsql plan cache
In-Reply-To: <op.u8jnpjikeorkce@localhost>
* 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