Clustering in the presence of hierarchies

Поиск
Список
Период
Сортировка
Искать
От
Ioannis Theoharis
Тема
Clustering in the presence of hierarchies
Дата
Msg-id
Pine.GSO.4.58.0412100503520.21724@calliope
Список



I'd like to ask you about the clustering strategy that postgres
implements.

Exactly: I have created a hierachy of tables using 'inherits'
relationship. I have populated tables with a huge amount of data and then
I cluster each table according to an attribute that exists on Root table
(hence, this attribute is inherited by all tables).

In general, clustering for each of those table means to reorder on disc
tuples, in order to be sequential stored.

The question is:
Does postgres uses the knowledge of the hierarchy structure
to reorder tuples of each table to be stored almost after
its direct paent-table tuples?


В списке pgsql-general по дате отправления
От: Geoffrey
Дата:
Сообщение: Re: postgresql and javascript
От: Marcel Gsteiger
Дата:
FAQ