Well I think this is the latest post I have ever done. I watched the MacWorld 2006 video this evening, which was cool, and decided that I would run a vacuumdb on the Spam database (housed in a PostgresDB on a 8way UltraSparcIII with 32 GB of ram Sun F12k Domain) since I was running out of room in the file system that holds it. (Currently the DB is over 50GB in size). The last time I ran this it took about 2 hours to do it, it has now been running for 4 hours and it still going… To top that off, for what ever reason Adelphia’s Digital Cable decided to go out tonight, I still get all the analog channels, just non of the digital cables work, which makes me mad as I was going to tape a couple of movies tonight, but all I got was black. Tried cycling the power on the reciever, nothing, tried changing to different channels, nothing. Even went in to the service mode (SA Explorer 3100, hold down the + on the front of the receiver and then when the “email light” comes on release and press the info button, 21 pages of goodness) and everything looked fine. So I guess I will wait and see what happens later today.
Anyways, back to the Spam DB, as I have been sitting here, it took 2.3 hours just to
go through one table. Does any one know how to make the vacuumdb run faster? The box is almost completely idle… I have done similar stuff in MySQL and it takes no where as long as this does. (Granted I am not as familiar with Postgres as I am with MySQL.)