Thankstoitsreliability,robustness,andhighperformance,PostgreSQLhasbecomethemostadvancedopensourcedatabaseonthemarket.ThisthirdeditionofMasteringPostgreSQLhelpsyoubuilddynamicdatabasesolutionsforenterpriseapplicationsusingthelatestreleaseofPostgreSQL,whichenablesdatabaseanalyststodesignbothphysicalandtechnicalaspectsofsystemarchitecturewithease.StartingwithanintroductiontothenewlyreleasedfeaturesinPostgreSQL12,thisbookwillhelpyoubuildefficientandfault-tolerantPostgreSQLapplications.You’llthoroughlyexaminetheadvancedfeaturesofPostgreSQL,includinglogicalreplication,databaseclusters,performancetuning,monitoring,andusermanagement.You’llalsoworkwiththePostgreSQLoptimizer,configurePostgreSQLforhighspeed,andunderstandhowtomovefromOracletoPostgreSQL.Asyouprogressthroughthechapters,you’llcovertransactions,locking,indexes,andhowtooptimizequeriesforimprovedperformance.Additionally,you’lllearnhowtomanagenetworksecurityandexplorebackupsandreplicationswhileunderstandingusefulPostgreSQLextensionstohelpyouinoptimizingtheperformanceoflargedatabases.BytheendofthisPostgreSQLbook,you’llbeabletogetthemostoutofyourdatabasebyimplementingadvancedadministrativetaskseffortlessly.