Re: Memory usage during sorting

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Memory usage during sorting
Date: 2012-02-04 18:12:16
Message-ID: CAMkU=1zDa=7_4fjFuWbhd0NR31JKQrxPjkwSgM+9dMWTugatcA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Feb 4, 2012 at 10:06 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)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;

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2012-02-04 18:37:40 Re: [BUGS] BUG #6425: Bus error in slot_deform_tuple
Previous Message Jeff Janes 2012-02-04 18:06:38 Re: Memory usage during sorting