Re: "Consider compacting this relation..." ??? - Mailing list pgsql-general

"Scott Marlowe" <scott.marlowe@gmail.com> writes:
> On Thu, Feb 28, 2008 at 3:14 PM, Kynn Jones <kynnjo@gmail.com> wrote:
>> What does the hint mean by "compacting"?  What exactly must I do to compact
>> this table?

> Vacuum full

CLUSTER is a good alternative also, though pre-8.3 you need to consider
that it's not MVCC-safe; that could be important in heavily concurrent
applications.

            regards, tom lane