PostgreSQL CLUSTER on multi-column index

Question

Say I have an index on (a, b, c) and I perform CLUSTER on that index. How exactly will the data be stored? I would assume it's something like this (just guessing): first sort by a, then by b, then by c. For example:

(a, b, c)
---------
(1, 1, 1)
(1, 1, 2)
(1, 2, 5)
(2, 1, 4)
(3, 1, 1)

That means, if I want to have it ordered by b first, I can drop the index, re-create it as (b, a, c), then CLUSTER?

Stephen Denne · Accepted Answer · 2010-07-06 04:23:39Z

4

Yes, CLUSTER recreates the table in the order of the index.

To get (b,a,c) you could also create a new index, then cluster on that new index, then remove the index.

answered Jul 6, 2010 at 4:23

Stephen Denne

37.2k10 gold badges49 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL CLUSTER on multi-column index

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related