Re: plpgsql plan cache

From: Pierre C
Subject: Re: plpgsql plan cache
Date: ,
Msg-id: op.u8jnpjikeorkce@localhost
(view: Whole thread, Raw)
In response to: plpgsql plan cache  (Joel Jacobson)
Responses: Re: plpgsql plan cache  (Joel Jacobson)
List: pgsql-performance

Tree view

plpgsql plan cache  (Joel Jacobson, )
 Re: plpgsql plan cache  ("Pierre C", )
  Re: plpgsql plan cache  (Joel Jacobson, )
   Re: plpgsql plan cache  (Tom Lane, )
   Re: plpgsql plan cache  (Nikolas Everett, )
    Re: plpgsql plan cache  (Joel Jacobson, )
 Re: plpgsql plan cache  ("Pierre C", )

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


pgsql-performance by date:

From: Greg Smith
Date:
Subject: Re: SSD + RAID
From: Scott Marlowe
Date:
Subject: Re: SSD + RAID