Re: plpgsql plan cache
От
Pierre C
Тема
Re: plpgsql plan cache
Дата
Msg-id
op.u8jnpjikeorkce@localhost
Ответ на
plpgsql plan cache (Joel Jacobson)
Список
Дерево обсуждения
plpgsql plan cache Joel Jacobson <joel@gluefinance.com>
Re: plpgsql plan cache "Pierre C" <lists@peufeu.com>
Re: plpgsql plan cache Joel Jacobson <joel@gluefinance.com>
Re: plpgsql plan cache Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql plan cache Nikolas Everett <nik9000@gmail.com>
Re: plpgsql plan cache Joel Jacobson <joel@gluefinance.com>
Re: plpgsql plan cache "Pierre C" <lists@peufeu.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 )
В списке pgsql-performance по дате отправления
