舉報 
會員
PostgreSQL High Performance Cookbook
Chitij Chauhan Dinesh Kumar 著
更新時間：2021-07-09 18:47:42
開會員，本書免費讀 >
IfyouareadeveloperoradministratorwithlimitedPostgreSQLknowledgeandwanttodevelopyourskillswiththisgreatopensourcedatabase,thenthisbookisidealforyou.Learninghowtoenhancethedatabaseperformanceisalwaysanexcitingtopictoeveryone,andthisbookwillshowyouenoughwaystoenhancethedatabaseperformance.
最新章節
- Detecting a missing index
- Forcing a query to use an index
- Finding unused indexes
- Partial indexes
- Combined indexes
- Concurrent indexes
品牌：中圖公司
上架時間：2021-07-09 18:08:15
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Detecting a missing index 更新時間：2021-07-09 18:47:42
- Forcing a query to use an index
- Finding unused indexes
- Partial indexes
- Combined indexes
- Concurrent indexes
- Clustering against an index
- Comparing indexed scans and sequential scans
- Index lookup
- Measuring query and index block statistics
- Introduction
- Chapter 12. Database Indexing
- Working on semi and anti joins
- Working with set operations
- Grouping
- Working with hash and merge join
- Nesting loops
- Running CTE scan
- Aggregate and hash aggregate
- Running bitmap heap and index scan
- Running sequential scans
- Computing basic cost
- Generating an explain plan
- Query plan node structure
- Clearing the cache
- Studying hot and cold cache behavior
- Timing overhead
- Using sample data sets
- Introduction
- Chapter 11. Query Optimization
- Replicating data from other databases to PostgreSQL using Goldengate
- Using the pg_upgrade utility for version upgrade
- Using pg_dump to upgrade data
- Introduction
- Chapter 10. Data Migration from Other Databases to PostgreSQL and Upgrading the PostgreSQL Cluster
- Control bloat using transaction age
- Monitoring vacuum progress
- Freezing and transaction ID wraparound
- Vacuum and autovacuum
- Dealing with bloating tables and indexes
- Introduction
- Chapter 9. Vacuum Internals
- Tuning with background writer statistics
- Generating planner statistics
- Routine reindexing
- Preventing page corruption
- Determining disk usage
- Logging slow statements
- Table access statistics
- Dealing with deadlocks
- Finding blocked sessions
- Finding out what the users are currently running
- Checking active sessions
- Introduction
- Chapter 8. Database Monitoring and Performance
- Using walctl to create replica
- Setting up walctl
- Using repmgr to create replica
- Setting up repmgr
- WAL management with OmniPITR
- Setting up OmniPITR
- Backup and recovery using Barman
- Setting up Barman
- Introduction
- Chapter 7. Working with Third-Party Replication Management Utilities
- Setting up a Postgres-XL cluster
- Replication using DRBD
- Replication using Bucardo
- Replication using Londiste
- Replication using Slony
- Setting up hot streaming replication
- Introduction
- Chapter 6. High Availability and Replication
- Partitioning with PL/Proxy
- Installing PL/Proxy
- Managing partitions
- Implementing partitioning
- Managing PgBouncer
- Connection pooling using PgBouncer
- Installing PgBouncer
- Configuring pgpool and testing the setup
- Installing pgpool-II
- Introduction
- Chapter 5. Connection Pooling and Database Partitioning
- Monitoring network status
- Monitoring disk space
- Tracking historical memory usage
- Tracking historical CPU usage
- Monitoring system load
- Identifying disk I/O bottlenecks
- Identifying CPU bottlenecks
- Monitoring CPU load
- Tracking CPU consuming processes
- Monitoring paging and swapping
- Monitoring CPU usage
- Introduction
- Chapter 4. Monitoring Server Performance
- Analyzing buffer cache contents
- Identifying checkpoint overhead
- Disk tuning parameters
- CPU scheduling parameters
- Handling Linux/Unix memory parameters
- Understanding memory units in PostgreSQL
- Introduction
- Chapter 3. Device Optimization
- Tuning logging-related parameters
- Tuning query-related parameters
- Tuning connection-related parameters
- Restarting the database server quickly
- Reloading server configuration
- Stopping the server in an emergency
- Stopping the server quickly
- Starting the server manually
- Introduction
- Chapter 2. Server Configuration and Control
- Running read/write pgbench test cases
- Configuring pgbench
- Discussing RAID levels
- Storage sizing
- Checking IOPS
- Working with the fsync commit rate
- Performing a seek rate test
- Disk benchmarking
- Memory benchmarking
- CPU benchmarking
- Introduction
- Chapter 1. Database Benchmarking
- Preface
- Customer Feedback
- www.PacktPub.com
- About the Reviewers
- About the Authors
- Credits
- 版權信息
- 封面
- 封面
- 版權信息
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Customer Feedback
- Preface
- Chapter 1. Database Benchmarking
- Introduction
- CPU benchmarking
- Memory benchmarking
- Disk benchmarking
- Performing a seek rate test
- Working with the fsync commit rate
- Checking IOPS
- Storage sizing
- Discussing RAID levels
- Configuring pgbench
- Running read/write pgbench test cases
- Chapter 2. Server Configuration and Control
- Introduction
- Starting the server manually
- Stopping the server quickly
- Stopping the server in an emergency
- Reloading server configuration
- Restarting the database server quickly
- Tuning connection-related parameters
- Tuning query-related parameters
- Tuning logging-related parameters
- Chapter 3. Device Optimization
- Introduction
- Understanding memory units in PostgreSQL
- Handling Linux/Unix memory parameters
- CPU scheduling parameters
- Disk tuning parameters
- Identifying checkpoint overhead
- Analyzing buffer cache contents
- Chapter 4. Monitoring Server Performance
- Introduction
- Monitoring CPU usage
- Monitoring paging and swapping
- Tracking CPU consuming processes
- Monitoring CPU load
- Identifying CPU bottlenecks
- Identifying disk I/O bottlenecks
- Monitoring system load
- Tracking historical CPU usage
- Tracking historical memory usage
- Monitoring disk space
- Monitoring network status
- Chapter 5. Connection Pooling and Database Partitioning
- Introduction
- Installing pgpool-II
- Configuring pgpool and testing the setup
- Installing PgBouncer
- Connection pooling using PgBouncer
- Managing PgBouncer
- Implementing partitioning
- Managing partitions
- Installing PL/Proxy
- Partitioning with PL/Proxy
- Chapter 6. High Availability and Replication
- Introduction
- Setting up hot streaming replication
- Replication using Slony
- Replication using Londiste
- Replication using Bucardo
- Replication using DRBD
- Setting up a Postgres-XL cluster
- Chapter 7. Working with Third-Party Replication Management Utilities
- Introduction
- Setting up Barman
- Backup and recovery using Barman
- Setting up OmniPITR
- WAL management with OmniPITR
- Setting up repmgr
- Using repmgr to create replica
- Setting up walctl
- Using walctl to create replica
- Chapter 8. Database Monitoring and Performance
- Introduction
- Checking active sessions
- Finding out what the users are currently running
- Finding blocked sessions
- Dealing with deadlocks
- Table access statistics
- Logging slow statements
- Determining disk usage
- Preventing page corruption
- Routine reindexing
- Generating planner statistics
- Tuning with background writer statistics
- Chapter 9. Vacuum Internals
- Introduction
- Dealing with bloating tables and indexes
- Vacuum and autovacuum
- Freezing and transaction ID wraparound
- Monitoring vacuum progress
- Control bloat using transaction age
- Chapter 10. Data Migration from Other Databases to PostgreSQL and Upgrading the PostgreSQL Cluster
- Introduction
- Using pg_dump to upgrade data
- Using the pg_upgrade utility for version upgrade
- Replicating data from other databases to PostgreSQL using Goldengate
- Chapter 11. Query Optimization
- Introduction
- Using sample data sets
- Timing overhead
- Studying hot and cold cache behavior
- Clearing the cache
- Query plan node structure
- Generating an explain plan
- Computing basic cost
- Running sequential scans
- Running bitmap heap and index scan
- Aggregate and hash aggregate
- Running CTE scan
- Nesting loops
- Working with hash and merge join
- Grouping
- Working with set operations
- Working on semi and anti joins
- Chapter 12. Database Indexing
- Introduction
- Measuring query and index block statistics
- Index lookup
- Comparing indexed scans and sequential scans
- Clustering against an index
- Concurrent indexes
- Combined indexes
- Partial indexes
- Finding unused indexes
- Forcing a query to use an index
- Detecting a missing index 更新時間：2021-07-09 18:47:42
