Luke Lonergan wrote:

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:

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not

Reply via email to