PostgreSQL fun
November 11th, 2006
Found out last night that our SPAM server’s database was a little corrupted.. It is a PostgreSQL DB and it was over 80 gigs in size. So today I have spent so far 3+ hours getting it rebuilt.. First deleted (moved out of the way) the entire postgres directory and reinstalled it and populated some config info back in to it. Now comes the long task of reindexing the spam queue. Right now there are 5.5 million messages (just from the last 8 days) in the queue and the reindex has been running for only about 30 minutes, and it is only 8% done. going on that, looks like I will be here for a while. but since it is pouring the rain down outside, not much I can do any ways.
