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 по дате отправления