會員

PostgreSQL Administration Essentials

更新時間：2021-08-05 17:41:10

開會員，本書免費讀 >

IfyouareadatabaseadministratorwhoneedstogettogripswithPostgreSQLquicklyandefficiently,thenthisbookisforyou.Thisbookwillalsobehighlybeneficialifyouareaprojectleaderoradeveloperwhoisinterestedinknowingmoreaboutdatabasesystemsorbottleneckdetection,asitwillenableyoutoworkmorecloselyandcooperativelywithyouradministrators.

目錄(55章)

倒序

封面
版權頁
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Free access for Packt account holders
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Installing PostgreSQL
Preparing your setup
Understanding the existing databases
Creating databases
Summary
Chapter 2. Indexing and Performance Tuning
Using simple binary trees
Understanding the concept of execution plans
Dealing with different types of indexes
Detecting missing indexes
Detecting slow queries
Adjusting memory parameters
Summary
Chapter 3. Users and Permissions
Understanding PostgreSQL security
Summary
Chapter 4. Managing Logfiles
Understanding the PostgreSQL log architecture
Configuring the amount of log output
Making log creation more fine grained
Summary
Chapter 5. Backup and Recovery
Importing and exporting data
Performing backups
Summary
Chapter 6. Handling Replication and Improving Performance
Understanding the PostgreSQL transaction log
Configuring the checkpoints
Setting up an asynchronous replication
Upgrading to synchronous replication
Improving and monitoring the replication
Handling point-in-time recovery
Understanding timelines
Summary
Chapter 7. Monitoring PostgreSQL
Understanding the system statistics of PostgreSQL
Integrating Nagios
Handling Linux cgroups
Summary
Index 更新時間：2021-08-05 17:41:10

官术网_书友最值得收藏!

PostgreSQL Administration Essentials