On Thu, Sep 1, 2016 at 12:31 AM, Nicolas Grilly <nicolas@xxxxxxxxxxxxxxxx> 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:
