PSQL Radio: Time for a Tune-Up?

Cars require some basic maintenance; oil changed every 3,000 miles, tires checked or even a basic engine tune-up. Like your car, your database has certain items that need to be checked and maintained on a regular basis.

In this month's PSQL Radio edition Product Manager, Jim Beecher, provides some tips and information on how to optimize system performance and keep your database from stalling.

Questions that are answered in this month’s edition are:

• Why do I need to “tune-up” my database?
• What utilities are available to help me ensure system optimization?
• How do I monitor the number of users, files or threads/handles being used?
• What should I regularly monitor?
• Does the Cache Allocation Size affect performance?
• What are the recommended threshold settings?
• Is disk optimization critical to performance?
• How often should I rebuild my data application files?
• How much effort is required to complete this maintenance?
  
  

Regular maintenance of your database is the key to reliability and optimized performance. Keeping your engine running smoothly requires minimal effort using the guidelines presented in this month’s PSQL Radio and will ensure your database is "tuned-up" and ready to go.

Click on the player button above to listen to PSQL Radio. This audio requires the Flash plug-in, which you can download for free here. You can also download the audio in MP3 format here.