Re: Memory usage during sorting

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Memory usage during sorting
Дата
Msg-id CAMkU=1zDa=7_4fjFuWbhd0NR31JKQrxPjkwSgM+9dMWTugatcA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Memory usage during sorting  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
On Sat, Feb 4, 2012 at 10:06 AM, Jeff Janes <jeff.janes@gmail.com> wrote:

> Attached is a completely uncommitable proof of concept/work in
> progress patch to get around the limitation.  It shows a 2 fold
> improvement when indexing an integer column on a 50,000,000 row
> randomly ordered table.

Oops, forgot to say that is with
set maintenance_work_mem=4194304;


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Memory usage during sorting
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: [BUGS] BUG #6425: Bus error in slot_deform_tuple