Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ok here's the update after ~30 hours we have killed vacuum full and
did vacuum on the tables we freed.
However, VACUUM hasn't freed any space at all 0_o
We want to launch vacuum full on per-table basis but we can't have any
more downtime right now so we will launch it at night today.

The original question still stands, is there any way to diagnose
vacuum full time-to-run?
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?

I wonder why are people only trying to help w/simple question or when
I flame 0_o



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux