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@xxxxxxxxx> wrote: > > On 11/6/07, j a <inboundfilter@xxxxxxxxx> 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. > ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate