Re: CLUSTER and clustered indices

Simon Riggs <simon@2ndquadrant.com> writes:
> When a table has been CLUSTERed on a particular index AND that index
> values is monotonically increasing, then it would be a bad move to use
> blocks from the FSM since this would tend to destroy the natural
> clustering sequence.

By the time there are any blocks in FSM to take, the original clean
index page sequence is doubtless history.  The pure-increasing-key
scenario you are thinking of never will have any FSM entries, so it's
moot.
        regards, tom lane