1968
06-25-2009, 08:15 AM
Have had trouble vacuuming for a while now (since I had a power outage a few months ago). I get an error saying 'please vacuum your db through pgadmin'.. is there any way to fix this?..
Also, when I try defraging my drive, I get a whole heap of PosgreSQL files that wont degrag.. what could be causing this?.. can any of these files be deleted?..
Report after degrag:
Fragments File Size Files that cannot be defragmented
3,284 480 MB \Program Files\PostgreSQL\8.3\data\base\16403\16471
3,149 639 MB \Program Files\PostgreSQL\8.3\data\base\16403\16510
3,714 684 MB \Program Files\PostgreSQL\8.3\data\base\16403\16503
9,118 856 MB \Program Files\PostgreSQL\8.3\data\base\16403\16430.3
5,948 965 MB \Program Files\PostgreSQL\8.3\data\base\16403\16468.1
3,440 1,019 MB \Program Files\PostgreSQL\8.3\data\base\16403\16456
8,393 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16453.1
8,410 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16430
8,456 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16453
4,657 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16468
8,842 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16430.2
4,221 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16430.1
Also, when I try defraging my drive, I get a whole heap of PosgreSQL files that wont degrag.. what could be causing this?.. can any of these files be deleted?..
Report after degrag:
Fragments File Size Files that cannot be defragmented
3,284 480 MB \Program Files\PostgreSQL\8.3\data\base\16403\16471
3,149 639 MB \Program Files\PostgreSQL\8.3\data\base\16403\16510
3,714 684 MB \Program Files\PostgreSQL\8.3\data\base\16403\16503
9,118 856 MB \Program Files\PostgreSQL\8.3\data\base\16403\16430.3
5,948 965 MB \Program Files\PostgreSQL\8.3\data\base\16403\16468.1
3,440 1,019 MB \Program Files\PostgreSQL\8.3\data\base\16403\16456
8,393 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16453.1
8,410 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16430
8,456 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16453
4,657 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16468
8,842 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16430.2
4,221 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16430.1