Re: How check execution plan of a function

От Kevin Grittner
Тема Re: How check execution plan of a function
обсуждение исходный текст
Ответ на Re: How check execution plan of a function  ("Sabin Coanda")
Список pgsql-performance
"Sabin Coanda" <> wrote:

> I have just a function returning a cursor based on a single coplex
> query. When I check the execution plan of that query it takes
> about 3 seconds. Just when it is used inside the function it
> freezes.
> This is the problem, and this is the reason I cannot imagine what
> is happen.
> Also I tried to recreate the function as it was before when it run
> in 3 seconds, but I cannot make it to run properly now.

You've given three somewhat confusing and apparently contradictory
descriptions of the problem or problems you've had with slow queries
-- all on one thread.  You would probably have better luck if you
start with one particular issue and provided more of the information
suggested here:

If we can solve one problem, perhaps the resolution to the others
will become apparent; otherwise follow up with the next.


В списке pgsql-performance по дате отправления:

От: Robert Haas
Сообщение: Re: function performs differently with different values
От: norn
Сообщение: Re: significant slow down with various LIMIT