Re: pgsql: Buffering GiST index build algorithm.

From: Thom Brown <thom(at)linux(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Buffering GiST index build algorithm.
Date: 2011-09-08 15:04:21
Message-ID: CAA-aLv4s9hKYqHz0XLxUQSojKac=jDJjexCCTiF5oL6fwKmHCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On 8 September 2011 15:56, Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi> wrote:
> Buffering GiST index build algorithm.
>
> When building a GiST index that doesn't fit in cache, buffers are attached
> to some internal nodes in the index. This speeds up the build by avoiding
> random I/O that would otherwise be needed to traverse all the way down the
> tree to the find right leaf page for tuple.

Sorry Heikki...

s/additionaly/additionally/

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2011-09-08 15:18:48 pgsql: Fix typo and reword the sentence.
Previous Message Heikki Linnakangas 2011-09-08 14:56:09 pgsql: Buffering GiST index build algorithm.