On Mon, Apr 22, 2024, 08:37 Ron Johnson <[email protected]> wrote:
> On Mon, Apr 22, 2024 at 10:25 AM Tom Lane <[email protected]> wrote: > >> Marcos Pegoraro <[email protected]> writes: >> > But wouldn't it be good that VACUUM FULL uses that index defined by >> > Cluster, if it exists ? >> >> No ... what would be the difference then? >> > > What the VACUUM docs "should" do, it seems, is suggest CLUSTER on the PK, > if the PK is a sequence (whether that be an actual sequence, or a timestamp > or something else that grows monotonically). > > That's because the data is already roughly in PK order. > If things are bad enough to require a vacuum full that doesn't seem like a good assumption. Any insert-only table or one with a reduced fill-factor maybe. David J
