Re: finding out vacuum completion %, and vacuum VS vacuum full

"Steve Atkins" <steve@blighty.com> writes:

> On Aug 7, 2007, at 1:17 AM, Sergei Shelukhin wrote:
>
>> Or any way to optimize it besides the obvious (maintenace_work_mem &
>> max_fsm_pages increases and no workload)?
>> Can someone please help with this one?

What does the output of "vacuum verbose" say?

> If you have adequate disk space free (enough to hold another
> copy of the new table) and the table has an index on it, then
> CLUSTER the table.

Or you can use ALTER TABLE to change the type of a column which forces the
whole table to be rewritten.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com