| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Demitri Muna <postgresql(at)demitri(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: CLUSTER, VACUUM, and TABLESPACEs (oh my) |
| Date: | 2021-01-25 06:38:48 |
| Message-ID: | CAECtzeWkVj_FCZ8ppPJvL4jUdJZ6p16uor2BRJdFpt-nPWkD6w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Le lun. 25 janv. 2021 à 03:27, Demitri Muna <postgresql(at)demitri(dot)com> a
écrit :
>
> > On Jan 24, 2021, at 9:03 PM, Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> wrote:
> >
> >> VACUUM FULL unclusters the table??
> >
> > It will rebuild the table without sorting the data according to the
> index used with CLUSTER (without any sorting actually).
>
> Thank you for the clarification; that’s very helpful. For the case above.
> If I CLUSTER a table, add/delete no rows, then VACUUM, will the existing
> order remain or be changed?
>
As long as you don't insert or update any rows, the order should remain
even after a VACUUM FULL.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James B. Byrne | 2021-01-25 19:17:42 | Need another set of eyes on this |
| Previous Message | Tom Lane | 2021-01-25 05:39:36 | Re: Can I use Postgres rules to reset session variables before/after queries? |