Aw: Re: REINDEX vs VACUUM
| От | Karsten Hilbert |
|---|---|
| Тема | Aw: Re: REINDEX vs VACUUM |
| Дата | |
| Msg-id | trinity-9bbd056e-3733-4b57-8a37-e7651476163d-1672918448300@3c-app-gmx-bs24 обсуждение исходный текст |
| Ответ на | Re: REINDEX vs VACUUM ("Peter J. Holzer" <hjp-pgsql@hjp.at>) |
| Ответы |
Re: REINDEX vs VACUUM
|
| Список | pgsql-general |
> Von: "Peter J. Holzer" <hjp-pgsql@hjp.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
В списке pgsql-general по дате отправления: