Re: Replacing Cursors with Temporary Tables

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Replacing Cursors with Temporary Tables
Дата
Msg-id x2kb42b73151004220517q6e6435bbrdb89dd84627ccc31@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replacing Cursors with Temporary Tables  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
On Thu, Apr 22, 2010 at 8:14 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
> This will use an index on bar.bar_id if it exists.  Obviously, any
> indexes on foo are not used after creating the array but doesn't
> matter much as long as the right side is indexed.  Your cursor method
> does do any better in this regard.  You can create an index on a temp

er, meant to say: 'doesn't do any better'.

merlin

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

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