Re: plpgsql plan cache

From: "Pierre C" <lists(at)peufeu(dot)com>
To: "Joel Jacobson" <joel(at)gluefinance(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: plpgsql plan cache
Date: 2010-02-22 19:42:44
Message-ID: op.u8jnpjikeorkce@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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 )

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joel Jacobson 2010-02-22 19:58:10 Re: plpgsql plan cache
Previous Message Joel Jacobson 2010-02-22 19:26:49 plpgsql plan cache