"Steve Atkins" <steve@xxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
