Re: Memory usage during sorting - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Memory usage during sorting
Date
Msg-id CAMkU=1zDa=7_4fjFuWbhd0NR31JKQrxPjkwSgM+9dMWTugatcA@mail.gmail.com
Whole thread Raw
In response to Re: Memory usage during sorting  (Jeff Janes <jeff.janes@gmail.com>)
List 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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Memory usage during sorting
Next
From: Simon Riggs
Date:
Subject: Re: [BUGS] BUG #6425: Bus error in slot_deform_tuple