Hi,
On 2022-06-15 19:07:50 -0700, Mark Dilger wrote:
> > On Jun 15, 2022, at 6:55 PM, Andres Freund <andres@anarazel.de> wrote:
> >
> > I think nothing would happen in this case - only pre-clustered tables get
> > clustered in an argumentless CLUSTER. What am I missing?
>
> The "VACUUM FULL" synonym of "CLUSTER" doesn't depend on whether the target
> is pre-clustered
VACUUM FULL isn't a synonym of CLUSTER. While a good bit of the implementation
is shared, VACUUM FULL doesn't order the table contents. I see now reason why
an AM shouldn't support VACUUM FULL?
> , and both will run against the table if the user has run an ALTER
> TABLE..CLUSTER ON.
If a user does that for a table that doesn't support clustering, well, I don't
see what's gained by not erroring out.
Greetings,
Andres Freund