Bruce Momjian wrote:
>
> > Bruce Momjian <pgman@candle.pha.pa.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