Re: Name for new VACUUM

Bruce Momjian wrote:
>
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > >> Not necessarily. Concurrent VACUUM does truncate the relation if it can
> > >> do so conveniently --- for example, it will successfully reclaim space
> > >> if you do "DELETE FROM foo; VACUUM foo;". It just doesn't try as hard
> > >> as the older VACUUM code does.
> >
> > > But it will not reclaim from UPDATE.
> >
> > What? I have no idea what you mean by that.
>
> I meant that UPDATE of all rows in a table put the new rows at the end.

OTOH if you do it twice it will reclaim ;)

UPDATE everything;
VACUUM;
UPDATE everything;
VACUUM;

---------------
Hannu