"Steve Atkins" <steve(at)blighty(dot)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