View Full Version : vacuum analyze - no disk space remaining
cokedrinker
11-03-2011, 04:01 PM
hey,
i purged a bunch of hands last night and tried to vacuum analyze in pgadmin3 to free up some space but the program keeps stalling, saying that ive no disk space remaining
i have like 50mb left when running the program, any idea how much i should need? to vacuum analyze say a 60gig database..
i could transfer the whole database to a bigger hard drive i guess but was hoping there was a quicker fix
cokedrinker
11-03-2011, 05:05 PM
last few lines from latest log:
CPU 3.46s/4.44u sec elapsed 44.23 sec.INFO: index "playervsplayer_idx1" now contains 18353533 row versions in 179664 pages
DETAIL: 13527091 index row versions were removed.
597 index pages have been deleted, 597 are currently reusable.
CPU 3.33s/13.86u sec elapsed 69.00 sec.INFO: index "playervsplayer_idx2" now contains 18353533 row versions in 138996 pages
DETAIL: 13527091 index row versions were removed.
49362 index pages have been deleted, 49362 are currently reusable.
CPU 1.71s/11.07u sec elapsed 36.04 sec.ERROR: could not extend relation base/288660/375322: No space left on device
HINT: Check free disk space.
ERROR: could not extend relation base/288660/375322: No space left on device
HINT: Check free disk space.
any idea how much would i have to free up?? every last mb is precious right now
Patvs
11-05-2011, 01:25 AM
To fully vacuum/analyse... or reindex.. or backup a 60 GB database. You need about 30-60 GB of free disk space.
60 GB!? Check if you can delete the log files in the Program Files/PostgreSQL/8.4/data/pg_log folder.
Or move the entire data folder to a bigger drive: http://faq.holdemmanager.com/questions/368/MoveDatabaseToAnotherHardDriveOrPartition
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.