On Thu, Sep 1, 2016 at 12:31 AM, Nicolas Grilly <nico...@gardentechno.com> wrote:
> In DB2, it seems possible to define a "clustering index" that determines > how rows are physically ordered in the "table space" (the heap). > > The documentation says: "When a table has a clustering index, an INSERT > statement causes DB2 to insert the records as nearly as possible in the > order of their index values." > > It looks like a kind of "continuous CLUSTER/pg_repack". Is there something > similar available or planned for PostgreSQL? > I forgot the links to DB2 documentation about clustering index: http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/intro/src/tpc/db2z_clusteringindexes.html http://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0061098.html
