> Added to TODO: > > o Cluster all tables at once using pg_index.indisclustered or primary key > > > > And what happens with those tables that do not have any such index? > > > > Nothing, would be my vote. You'd just re-CLUSTER all tables that have > > been clustered before, the same way they were last clustered.
I second Tom's opinion. If the table was not clustered before leave it as is. Thus the TODO should imho (if at all :-) read: o Cluster all tables at once that have a pg_index.indisclustered Andreas ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html