Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group