09-23, 12:00–12:30 (Europe/London), Assembly Room
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.
Karen was a database administrator for over 20 years and was once described as “quite personable for a DBA”, which she decided to take as a compliment. Karen is now a Senior Solutions Architect, helping customers to design and implement their (PostgreSQL) database systems. She's also desperately trying to learn enough Python to help her with her part time Computer Science PhD.
Outside of the world of databases, Karen loves cycling, mountain biking, skiing and spending time with her family in the mountains where she lives.