PostgreSQL high performance cookbook mastering query optimization database monitoring and performance-tuning for PostgreSQL

PostgreSQL high performance cookbook mastering query optimization, database monitoring, and performance-tuning for PostgreSQL Chauhan, Chitij, Kumar, Dinesh
Cover — Credits — About the Authors — About the Reviewers — www.PacktPub.com — Customer Feedback — Table of Contents — Preface — Chapter 1: Database Benchmarking — Introduction — CPU benchmarking — Getting ready — How to do it… — Phoronix — sysbench — How it works… — Phoronix — sysbench — Memory benchmarking — Getting ready — How to do it… — Phoronix — tmpfs — Write test — Read test — How it works… — Disk benchmarking — Getting ready — How to do it… — Phoronix — bonnie++ — How it works… — bonnie++ — Performing a seek rate test — Getting ready — How to do it… — How it works… — Working with the fsync commit rate — Getting ready — How to do it… — How it works… — Checking IOPS — Getting ready — How to do it… — Sequential mixed read and write — Random mixed read and write — How it works… — Storage sizing — Getting ready — How to do it… — How it works… — Discussing RAID levels — Getting ready — How to do it… — How it works… — RAID 0 — RAID 1 — RAID 5 — RAID 6 — RAID 10 — Configuring pgbench — Getting ready — How to do it… — How it works… — Running read/write pgbench test cases — Getting ready — How to do it… — Read-only — Write-only — How it works… — Chapter 2: Server Configuration and Control — Introduction — Starting the server manually — Getting ready — How to do it… — How it works… — Stopping the server quickly — Getting ready — How to do it… — How it works… — Stopping the server in an emergency — How to do it… — How it works… — Reloading server configuration — Getting ready — How to do it… — How it works… — Restarting the database server quickly — How to do it… — How it works… — Tuning connection-related parameters — How to do it… — How it works… — Tuning query-related parameters — How to do it… — How it works… — Tuning logging-related parameters Categories:
Computers – Databases
Year:
2017
Publisher:
Packt Publishing
Language:
english
Pages:
1 / 354
ISBN 10:
1785287249
ISBN 13:
9781785287244
File:
71 MB