vacuum analyze - no disk space remaining

[cokedrinker]

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]

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]

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