Re: REINDEX vs VACUUM

From: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: REINDEX vs VACUUM
Date: 2023-01-05 10:26:39
Message-ID: 20230105102639.ce2lyt3lx4l3z7ci@hjp.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2023-01-04 09:34:42 -0600, 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.

Move all the stuff from the living room to the bedroom and then jettison
the living room.

Isn't that how you normally vacuum your living room?

hp

--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2023-01-05 11:34:08 Aw: Re: REINDEX vs VACUUM
Previous Message Brad White 2023-01-05 08:51:08 Re: REINDEX vs VACUUM