Re: Vacuum Full

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Apr 01, 2009 at 08:09:31PM -0400, Tom Lane wrote:

> > Nowadays, with many many new users, and no historical context, they do
> > just take it for "a better kind of vacuum" when in fact it is really
> > like reindex to indexes.  I'd vote for rebuild [table]; as the new way
> > to spell vacuum full;
> 
> Well, no, "rebuild" is a pretty lousy description for it.  I'd expect
> "rebuild" to mean something like a no-op rewrite in ALTER TABLE.
> 
> It is true that VACUUM FULL's use case has decreased nearly to the
> vanishing point, and the maintenance effort for it is way out of
> proportion to the use case.  Maybe we should remove the code and make
> VACUUM FULL do the table-rewrite thing.

What do you mean with "the table-rewrite thing", exactly?

Tino.

-- 
"What we nourish flourishes." - "Was wir nähren erblüht."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux