Re: Slow set-returning functions

Поиск
Список
Период
Сортировка
От Marcin Stępnicki
Тема Re: Slow set-returning functions
Дата
Msg-id 1201461380.19607.6.camel@localhost
обсуждение исходный текст
Ответ на Re: Slow set-returning functions  (Dean Rasheed <dean_rasheed@hotmail.com>)
Список pgsql-performance
Dnia 27-01-2008, N o godzinie 17:29 +0000, Dean Rasheed pisze:
> The CONTEXT is very useful, particularly when functions call other
> functions, since it gives the call stack (presumably only for SQL and
> PL/pgSQL functions). For top-level queries I would ideally like the
> CONTEXT to log the SQL being executed, but I couldn't figure out how
> to access that information.
>
> Anyway, I'd be interested to know if anyone has thought about doing
> anything like this before and if anyone else might find this useful.
>
> Dean

I'd love to see that. The mentioned PREPARE workaround doesn't seem to
work when executed function calls for example three another (or I don't
know how to use it in such situation) - and is generally painful to
use.

I'm afraid I can't help you much (besides testing) but I'd be more than
interested in such improvement.

Regards,
Marcin


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

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Re: Slow set-returning functions
Следующее
От: "Stephen Denne"
Дата:
Сообщение: Re: 8.3rc1 Out of memory when performing update