From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Luke Lonergan <LLonergan@greenplum.com>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Subject: Block B-tree etc. (was Re: Introducing an advanced Frequent Update)
Date: Tue, 07 Nov 2006 09:51:21 +0000
Message-ID: <45505719.1070602@enterprisedb.com> (raw)
In-Reply-To: <3E37B936B592014B978C4415F90D662D04E6EB21@MI8NYCMAIL06.Mi8.com>
References: <3E37B936B592014B978C4415F90D662D04E6EB21@MI8NYCMAIL06.Mi8.com>
Luke Lonergan wrote:
> Simon,
>
> Bring it on! We at GP have been evaluating various approaches to index
> organized tables which unify index with heap storage to solve some of
> the problems you mention. Split index and heap is a big issue in
> Postgres and we'd all welcome a good solution to it, even for limited
> circumstances like single index organization or the like.
I don't think Simon's proposal is meant to address that issue, but did
you follow the thread I started in September about Block B-Tree index:
http://archives.postgresql.org/pgsql-hackers/2006-09/msg02041.php
That's our plan to achieve speedups that other DBMS's have achieved with
Index-Organized-Tables or Clustered Indexes. We're running initial
performance tests of it as we speak, and if all goes well we're hoping
to get that into PostgreSQL 8.3.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: heikki@enterprisedb.com, LLonergan@greenplum.com, simon@2ndquadrant.com
Subject: Re: Block B-tree etc. (was Re: Introducing an advanced Frequent Update)
In-Reply-To: <45505719.1070602@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox