Databases

NAVIGATION
CATEGORIES
REFERRENCE
LINKS
  • space not reclaimed after repeated full vacuums

    0 answers - 572 bytes - related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

    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!

Re: space not reclaimed after repeated full vacuums


max 4000 letters.
Your nickname that display:
In order to stop the spam: 0 + 9 =
QUESTION ON "Databases"

EMSDN.COM