Re: Weird performance drop

Поиск
Список
Период
Сортировка
От Dave Dutcher
Тема Re: Weird performance drop
Дата
Msg-id 01ea01c772d8$7b87aca0$2e00a8c0@tridecap.com
обсуждение исходный текст
Ответ на Re: Weird performance drop  (Vincenzo Romano <vincenzo.romano@gmail.com>)
Ответы Re: Weird performance drop  (Vincenzo Romano <vincenzo.romano@gmail.com>)
Список pgsql-performance
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of
> Vincenzo Romano
>
> Is there any "workaround"?
>
> In my opinion the later the query planner decisions are taken the more
> effective they can be.
> It could be an option for the function (body) to delay any
> query planner
> decision.

I think a possible workaround is to use a plpgsql function and the execute
statement. The docs will have more info.

Dave



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

Предыдущее
От: Dimitri
Дата:
Сообщение: Re: Shared buffers, db transactions commited, and write IO on Solaris
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Wrong plan sequential scan instead of an index one