Description
5 simple things you can put in place to make sure you have a database that runs smoothly and performs well.
You don't want to spend too much time looking after your database; you've got better things to do with your time. You do, however, want your database to run smoothly and perform well. Fortunately, there are a few simple things that you can do to make sure your database ticks along nicely in the background. I've put together my top 5 tips, based on things that have been useful to me as a DBA and as a database consultant. These are things you can put in place, without too much effort, to make sure your database works well. The focus will be on PostgreSQL, but most of the tips are also relevant to other databases. You'll come away with some simple ways to keep your database happy, leaving you free to concentrate on developing your application.