Re: CLUSTER vs. VACUUM FULL

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: CLUSTER vs. VACUUM FULL
Date: 2024-04-22 17:50:24
Message-ID: CAB-JLwY-N87MQt5A4v1oSAuVcS1mKxsPCoRW5k8yHMpvqxm7XQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em seg., 22 de abr. de 2024 às 11:25, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> escreveu:

> No ... what would be the difference then

Well, I think if a cluster index was defined sometime in a table, it should
be respected for next commands, including VACUUM FULL.
If I want to come back to PK or any other index I would use CLUSTER ...
USING PK_INDEX.

regards
Marcos

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-04-22 18:45:16 Re: CLUSTER vs. VACUUM FULL
Previous Message David G. Johnston 2024-04-22 16:29:21 Re: CLUSTER vs. VACUUM FULL