Creatingadatabaseinstance
FiringupPostgreSQL
Understandingtheexistingdatabases
Creatingdatabases
Summary
2.IndexingandPerformanceTuning
Usingsimplebinarytrees
Preparingthedata
Understandingtheconceptofexecutionplans
Calculatingcosts
Drawingimportantconclusions
Creatingindexes
Analyzingtheperformanceofaquery
TheinternalstructureofaB-treeindex
UnderstandingtheB-treeinternals
Providingasortedorder
Combinedindexes
Partialindexes
Dealingwithdifferenttypesofindexes
Detectingmissingindexes
Detectingslowqueries
Howtoresetstatistics
Adjustingmemoryparameters
Optimizingsharedbuffers
Consideringhugepages
Tweakingwork_mem
Improvingmaintenance_work_mem
Adjustingeffective_cache_size
Summary
3.UsersandPermissions
UnderstandingPostgreSQLsecurity
