I am mostly „hung up“ on extending the doc to make it even more usedul (by sharing my use cases).
As a user I want to know if CLUSTERing also frees space, and since it has the effect of doing so (and not pre-allocates, which is a bit odd),why not mention it. Btw where is that friendly community the Internet brags about? Gruss Bernd David G. Johnston wrote on 7. June 2024 20:44 (GMT +02:00): > On Fri, Jun 7, 2024, 10:57 Bernd Eckenfels <e...@zusammenkunft.net> wrote: > >> >> Is the following correct (I.e. it does not preserv free pages) and can >> be added? >> > > You are hung up on the idea of free pages when this operation makes them > irrelevant. Complete new files are written, populated to the extent of > fill factor, then the old files are removed. At no point do empty pages > get left over in the new file and they get treated the same as non-empty > pages in the old file - they are utterly destroyed. > > >> Sidenote how is the feeling about pointing to >> non-included extension? > > > Not going to happen. > > David J. > Gruß Bernd — https://bernd.eckenfels.net