PDA

View Full Version : How often should I be vacuuming/analyzing my DB if I datamine a ton?



Eclipse86
09-28-2008, 10:10 AM
Hey guys, so I've been datamining a ton and import probably on avg about 150k hands/day. If this is the case, how often should be I doing a vacuum/analyze?

morny
09-28-2008, 10:14 AM
Once every 2 weeks should be fine, or whenever you start to notice a drop in performance

Eclipse86
09-28-2008, 10:15 AM
Alright, thanks for the quick reply!