Re: Bugs/slowness inserting and indexing cubes

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Jay Levitt <jay(dot)levitt(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bugs/slowness inserting and indexing cubes
Date: 2012-02-08 20:10:38
Message-ID: CAPpHfdt9vX4sV5Hkp=F211RiFsM4gLgX-qws=2EaohF2z40S5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Feb 7, 2012 at 11:26 PM, Jay Levitt <jay(dot)levitt(at)gmail(dot)com> wrote:

> [*] psql:slowcube.sql:20: ERROR: node buffer of page being split (121550)
> does not exist
>
This looks like a bug in buffering GiST index build I've implemented during
my GSoC 2011 project. It looks especially strange with following setting:

> effective_cache_size = 3734MB
>
because buffering GiST index build just shouldn't turn on in this case when
index fits to cache. I'm goint to take a detailed look on this.

------
With best regards,
Alexander Korotkov.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-02-08 20:31:18 Re: [GENERAL] pg_dump -s dumps data?!
Previous Message Robert Haas 2012-02-08 19:53:36 Re: Bugs/slowness inserting and indexing cubes