Re: space not reclaimed after repeated full vacuums

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

 



Title: RE: [ADMIN] space not reclaimed after repeated full vacuums

> I left this running over the weekend, and was surprised to
> find the script still running in it's 25th iteration this
> morning, with basically no rows left in any of the non-static tables.
>
> The interesting thing was that the data partition still had
> almost 26GB of space used, no matter how much data was
> actually in the database.

FYI: I discovered the REINDEX command, and after calling REINDEX on all non-static tables that I'd been deleting from, I got back to roughly my starting point (176MB from 26GB!).

Whoa!


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux