Thread: Vacuum Doesn't Recover Disk Space
I have a large table that I remove around 10m rows from every 2 months. I try running Vacuum Full w/Analyze (both boxes checked in PG Admin), but the disk space is never returned to the system. Any way I can force this?
I'm running 7.4 on CentOS4.3
I'm running 7.4 on CentOS4.3
On 11/6/07, j a <inboundfilter@gmail.com> wrote: > I have a large table that I remove around 10m rows from every 2 months. I > try running Vacuum Full w/Analyze (both boxes checked in PG Admin), but the > disk space is never returned to the system. Any way I can force this? > > I'm running 7.4 on CentOS4.3 You likely have index bloat. try reindexing.
Thanks for the tip. I probably should've waited for vacuum to actually finish instead of cancelling it prematurely (thinking PG Admin was finished). On Nov 6, 2007 12:42 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote: > > On 11/6/07, j a <inboundfilter@gmail.com> wrote: > > I have a large table that I remove around 10m rows from every 2 months. I > > try running Vacuum Full w/Analyze (both boxes checked in PG Admin), but the > > disk space is never returned to the system. Any way I can force this? > > > > I'm running 7.4 on CentOS4.3 > > You likely have index bloat. try reindexing. >