Re: REINDEX vs VACUUM

From: Brad White <b55white(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: REINDEX vs VACUUM
Date: 2023-01-05 08:51:08
Message-ID: e704db4f-8c80-d4a9-f450-97443b0df7b6@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/4/2023 9:34 AM, Ron wrote:
> I don't think VACUUM FULL (copy the table, create new indices and
> other metadata all in one command) actually vacuums tables.  It's a
> misleading name.
>
> Something like REBUILD TABLE would be a better name.

Well s***.

That explains a lot. Thanks for clearing that up for me.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2023-01-05 10:26:39 Re: REINDEX vs VACUUM
Previous Message Bryn Llewellyn 2023-01-05 04:28:49 Re: What is the best setup for distributed and fault-tolerant PG database?