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

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