Re: Vacuum-full very slow

[Steve Crawford <scrawford(at)pinpointresearch(dot)com>]

> You could try CLUSTER instead of VACUUM FULL, as I think it should be
> faster.  And the indexes will be devoid of any bloat, which will be a
> nice side effect.
> 
> I wonder, though, if you set maintenance_work_mem too high and are
> causing the OS to swap?
> 

Hmmm, why would cluster be faster?

No swapping - "top" shows swap mem of 3MB used and that wasn't changing.
Just to be sure I ran "swapoff -a ; swapon -a" which brought it back to
zero and it's not budging from there.

Cheers,
Steve