Re: [PERFORM] Cursor vs Set Operation

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: [PERFORM] Cursor vs Set Operation
Дата
Msg-id CAHyXU0zhQeC+SfinvmjX1vSYdDfcxeukLV8_se7gMWyXM=S_tg@mail.gmail.com
обсуждение исходный текст
Ответ на [PERFORM] Cursor vs Set Operation  (patibandlakoshal <patibandlakoshal@gmail.com>)
Список pgsql-performance
On Mon, Oct 30, 2017 at 5:51 PM, patibandlakoshal
<patibandlakoshal@gmail.com> wrote:
> From performance standpoint I  thought set operation was better than Cursor.
> But I found Cursor to be more effective than Set operation. Is there a way
> we can force optimizer to use cursor plan. QUERY PLAN

You're going to have to be  a little more specific.  In particular, I
have no idea what a 'cursor plan' is.  What precise operations did you
do?

merlin


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: [PERFORM] Index-Advisor Tools
Следующее
От: Gunther
Дата:
Сообщение: [PERFORM] OLAP/reporting queries fall into nested loops over seq scans or otherhorrible planner choices