[GENERAL] I need your advice thank you

Good day to all ... I hope any one can give me an advice ... to optimize my database... im having a problem when i'm backing up my DB and also using vacuum for my DB... my CPU load goes up and no one can use my DB... most of the transaction comes from web server.. I just need ur good advice

[GENERAL] I need your advice

Good day to all ... I hope any one can give me an advice ... to optimize my database... im having a problem when i'm backing up my DB and also using vacuum for my DB... my CPU load goes up and no one can use my DB... most of the transaction comes from web server.. I just need ur good advice ...