PostgreSQL High Performance Cookbook.
Get to know effective ways to improve PostgreSQL's performance and master query optimization, and database monitoring. About This Book Perform essential database tasks such as benchmarking the database and optimizing the server's memory usage Learn ways to improve query performance and opt...
Saved in:
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham :
Packt Publishing,
2017.
|
| Subjects: | |
| Online Access: | Full text (Emerson users only) Full text (Emmanuel users only) Full text (NECO users only) Full text (MCPHS users only) Full text (Wentworth users only) |
Table of Contents:
- 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; How to do it ... ; How it works ... ; Chapter 3: Device Optimization; Introduction; Understanding memory units in PostgreSQL.
- Getting readyHow to do it ... ; shared_buffers; temp_buffers; work_mem; maintenance_work_mem; wal_buffers; max_stack_depth; effective_cache_size; How it works ... ; Handling Linux/Unix memory parameters; Getting ready; How to do it ... ; kernel.shmmax; kernel.shmall; kernel.shmmni; vm.swappiness; vm.overcommit_memory; vm.overcommit_ratio; vm.dirty_background_ratio; vm.dirty_ratio; How it works ... ; CPU scheduling parameters; Getting ready; How to do it ... ; kernel.sched_autogroup_enabled; kernel.sched_min_granularity_ns; kernel.sched_latency_ns; kernel.sched_wakeup_granularity_ns.
- Kernel.sched_migration_cost_nsHow it works ... ; Disk tuning parameters; Getting ready; How to do it ... ; CFQ; noop; Deadline; How it works ... ; Identifying checkpoint overhead; Getting ready; How to do it ... ; How it works ... ; Analyzing buffer cache contents; Getting ready; How to do it ... ; How it works ... ; Chapter 4: Monitoring Server Performance; Introduction; Monitoring CPU usage; Getting ready; How to do it ... ; How it works ... ; Monitoring paging and swapping; Getting ready; How to do it ... ; How it works ... ; Tracking CPU consuming processes; Getting ready; How to do it ... ; How it works ... ; Monitoring CPU load.