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

Hi Robert,
Yes, the same concept. Oracle's IOT feature is used often with TPC benchmarks.

Thanks,
Reza

> -----Original Message-----
> From: Robert Klemme [mailto:shortcutter(at)googlemail(dot)com]
> Sent: Thursday, July 05, 2012 5:30 AM
> To: Reza Taheri
> Cc: pgsql-performance(at)postgresql(dot)org; Andy Bond (abond(at)redhat(dot)com);
> Greg Kopczynski; Jignesh Shah
> Subject: Re: [PERFORM] The need for clustered indexes to boost TPC-V
> 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#CBB
> JEBIH
>
> Kind regards
>
> robert
>
> --
> remember.guy do |as, often| as.you_can - without end
> http://blog.rubybestpractices.com/