Re: Replacing Cursors with Temporary Tables

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: Replacing Cursors with Temporary Tables
Дата
Msg-id p2k2f4958ff1004240738i91f8b5eco8b4571f994e15254@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replacing Cursors with Temporary Tables  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: Replacing Cursors with Temporary Tables  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance


On Sat, Apr 24, 2010 at 2:23 PM, Merlin Moncure <mmoncure@gmail.com> wrote:

Well, you missed the most important part: not using cursors at all.
Instead of declaring a cursor and looping it to build the array, build
it with array().  That's what I've been saying: arrays can completely
displace both temp tables _and_ cursors when passing small sets around
functions.

with huge emphasis on the word small.


--
GJ

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Replacing Cursors with Temporary Tables
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Replacing Cursors with Temporary Tables