"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> writes:
> On Thu, Feb 28, 2008 at 3:14 PM, Kynn Jones <kynnjo(at)gmail(dot)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