| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Bernd Eckenfels <ecki(at)zusammenkunft(dot)net> |
| Cc: | PostgreSQL Documentation <pgsql-docs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: CLUSTER details |
| Date: | 2024-06-07 18:44:41 |
| Message-ID: | CAKFQuwbA+NYKBqOkBXDfDO19VBs-t-qsanoC+n6cYA3dRZH+Mg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Fri, Jun 7, 2024, 10:57 Bernd Eckenfels <ecki(at)zusammenkunft(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | yanliang lei | 2024-06-07 21:37:45 | Suggestion about tcp_keepalives_idle parameter in the document |
| Previous Message | Bernd Eckenfels | 2024-06-07 17:57:09 | Re: CLUSTER details |