Re: The need for clustered indexes to boost TPC-V performance

From: Robert Klemme <shortcutter(at)googlemail(dot)com>
To: Reza Taheri <rtaheri(at)vmware(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, "Andy Bond (abond(at)redhat(dot)com)" <abond(at)redhat(dot)com>, Greg Kopczynski <gregwk(at)vmware(dot)com>, Jignesh Shah <jshah(at)vmware(dot)com>
Subject: Re: The need for clustered indexes to boost TPC-V performance
Date: 2012-07-05 12:30:23
Message-ID: CAM9pMnPxJ8i53aP=n7azT8sF5xiuWJzHPP-e-6qHdWozJCUbpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On Wed, Jul 4, 2012 at 1:13 AM, Reza Taheri <rtaheri(at)vmware(dot)com> wrote:

> Checking online, the subject of clustered indexes for PostgreSQL comes up
> often. PGSQL does have a concept called “clustered table”, which means a
> table has been organized in the order of an index. This would help with
> sequential accesses to a table, but has nothing to do with this problem.
> PGSQL folks sometimes refer to what we want as “integrated index”.

I do understand this correctly that we are speaking about the concept
which is known under the term "index organized table" (IOT) in Oracle
land, correct?

http://docs.oracle.com/cd/E11882_01/server.112/e25789/indexiot.htm#CBBJEBIH

Kind regards

robert

--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-07-05 14:35:00 Re: ERROR: function crosstab(unknown, unknown) does not exist
Previous Message Magnus Hagander 2012-07-05 09:06:29 Re: question about source download site.

Browse pgsql-performance by date

  From Date Subject
Next Message Reza Taheri 2012-07-05 19:10:04 Re: The need for clustered indexes to boost TPC-V performance
Previous Message David Kerr 2012-07-05 05:53:57 Re: Drop statistics?