Aw: Re: REINDEX vs VACUUM

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Aw: Re: REINDEX vs VACUUM
Date: 2023-01-05 11:34:08
Message-ID: trinity-9bbd056e-3733-4b57-8a37-e7651476163d-1672918448300@3c-app-gmx-bs24
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Von: "Peter J. Holzer" <hjp-pgsql(at)hjp(dot)at>
> 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?

Well, yeah, I wouldn't expect the table to be *copied*. After all, there's
not that much use for more than one per living room.

Karsten

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2023-01-05 12:15:00 Re: REINDEX vs VACUUM
Previous Message Peter J. Holzer 2023-01-05 10:26:39 Re: REINDEX vs VACUUM