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

Поиск
Список
Период
Сортировка
От Robert Klemme
Тема Re: The need for clustered indexes to boost TPC-V performance
Дата
Msg-id CAM9pMnPxJ8i53aP=n7azT8sF5xiuWJzHPP-e-6qHdWozJCUbpw@mail.gmail.com
обсуждение исходный текст
Ответ на The need for clustered indexes to boost TPC-V performance  (Reza Taheri <rtaheri@vmware.com>)
Ответы Re: The need for clustered indexes to boost TPC-V performance  (Reza Taheri <rtaheri@vmware.com>)
Список pgsql-performance
On Wed, Jul 4, 2012 at 1:13 AM, Reza Taheri <rtaheri@vmware.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/

В списке pgsql-performance по дате отправления:

Предыдущее
От: David Kerr
Дата:
Сообщение: Re: Drop statistics?
Следующее
От: Reza Taheri
Дата:
Сообщение: Re: The need for clustered indexes to boost TPC-V performance