"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