PDA

View Full Version : Recently bought Solid State Hard Drive, is Management still neccessary?



royman07
08-05-2011, 09:56 PM
I just bought A SSD and found that you never have to defrag the drive. Does this apply to database maintenance as well? SSD's have a limited number of writes in its lifetime and just don't want to waste if it isn't necessary. My graphs and queries in HEM are flying though nearly never lags at all.

Thanks
Roy

Patvs
08-05-2011, 10:07 PM
You only have to run a vacuum (in pgadminIII), if you purged/deleted a LOT of hands and you want that diskspace back.
Other than that, you should still backup your database -like once a month- but you don't need to perform any maintenance on it.

Also you don't have to worry about wasting its lifespan by generating too much writes, even if you generated 20 GB of writes a day, the drive would still work for 15 years. (and even after those 15 years have passed, all the data will still be readable, so eventhough you can't write to the drive anymore, you can still copy those files to a different drive)