Re: GSoC proposal: Fast GiST index build

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GSoC proposal: Fast GiST index build
Date: 2011-04-04 16:46:06
Message-ID: BANLkTikJOUG3tFjKmRvQ9kuZSwLZM4XdQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Apr 4, 2011 at 7:04 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> On Mon, Apr 4, 2011 at 7:16 AM, Alexander Korotkov <aekorotkov(at)gmail(dot)com>
> wrote:
> > Project name
> > Fast GiST index build
>
> Would/could/should this be implemented in a manner similar to the
> existing "GIN fast update" feature?
>

I've mentioned this problem in item #2 in project details. In short. Problem
is in concurrent selects. Buffers size is significant and their scan in
concurrent select can cause significant slow down. Probably, compromise can
be achived by using for smaller buffers or something like this, but it's
topic of separate research. It doesn't seems to be feasible for me to give a
production solution of this problem during GSoC.

----
With best regards,
Alexander Korotkov.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-04-04 16:47:18 Re: Re: [COMMITTERS] pgsql: Support comments on FOREIGN DATA WRAPPER and SERVER objects.
Previous Message Alexander Korotkov 2011-04-04 16:38:24 Re: Proposal: q-gram GIN and GiST indexes