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?
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
