Learn?Changeparametersinyoursystemandfindouthowthatwillaffecttherestofyourdatabase?SummariestohelpDBAswithexperienceofotherdatabasesystems?Monitoryouruserssothatyoucanseewhethertheyareconnected,whattheyarerunning,andwhethertheiraccounthasbecomeblocked?Identifytemporarydataandtheeffectthatithasonyoursystem?Advancedtechnicaltipsandscriptsforexperiencedusers?Controltheautomaticdatabasemaintenanceprogram?Identifyandfixbloatedtablesandindexes?HowandwhentoVACUUMyourdatabasesAboutPostgreSQLisapowerful,opensource,enterprisedatabase.ThisPostgreSQL9AdministrationCookbookLITEbookdescribeskeyaspectsofthePostgreSQLopensourcedatabasesystem.ThebookwillhelpasysadminorDBAwithkeyadministrationissuesinPostgreSQL:configuration,monitoringanddiagnosis,andsettingupregularmaintenance.Thishands-onguidewillassistdevelopersworkingonlivedatabasessupportingweborenterprisesoftwareapplications.Tofindoutmoreaboutupgradingtothefulledition,visitwww.packtpub.com/lite-editionsandlogintoyouraccountforoffersandhelp.Ifyoudon’thaveanaccountonPacktPub.com,visittodayandsetoneup!Features?Administerandmaintainahealthydatabase?ConfigureyourPostgreSQLdatabasetoyourneeds?Monitoryourdatabaseandlearntodiagnoseanyproblems?PartofPackt'sCookbookseries:Eachrecipeisacarefullyorganizedsequenceofinstructionstocompletethetaskasefficientlyaspossible