Horton

Re: Bugs/slowness inserting and indexing cubes

Alexander Korotkov <aekorotkov@gmail.com>

View thread
From: Alexander Korotkov <aekorotkov@gmail.com>
To: Jay Levitt <jay.levitt@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2012-02-08T20:10:38Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. pg_dump: Further reduce reliance on global variables.

  2. Fix postmaster to attempt restart after a hot-standby crash.

On Tue, Feb 7, 2012 at 11:26 PM, Jay Levitt <jay.levitt@gmail.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.