A feature called the visibility map was introduced in PostgreSQL version 8.4. The visibility map keeps track of pages that contain the tuple visible to all transactions. The Index Only Scan
is used when all columns are part of the index and the visibility map shows that all the tuples on the page are visible to all. A detailed description of the visibility map can be found at http://www.postgresql.org/docs/current/static/storage-vm.html.
PostgreSQL 9.6 High Performance
By :
PostgreSQL 9.6 High Performance
By:
Overview of this book
<p>Database administrators and developers spend years learning techniques to configure their PostgreSQL database servers for optimal performance, mostly when they encounter performance issues. Scalability and high availability of the database solution is equally important these days. This book will show you how to configure new database installations and optimize existing database server installations using PostgreSQL 9.6.</p>
<p>You will start with the basic concepts of database performance, because all successful database applications are destined to eventually run into issues when scaling up their performance. You will not only learn to optimize your database and queries for optimal performance, but also detect the real performance bottlenecks using PostgreSQL tools and some external tools. Next, you will learn how to benchmark your hardware and tune your operating system. Optimize your queries against the database with the help of right indexes, and monitor every layer, ranging from hardware to queries. Moving on, you will see how connection pooling, caching, partitioning, and replication will help you handle increasing database workloads.</p>
<p>Achieving high database performance is not easy, but you can learn it by using the right guide—PostgreSQL 9.6 High Performance.</p>
Table of Contents (25 chapters)
Title Page
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface
Free Chapter
PostgreSQL Versions
Database Hardware
Database Hardware Benchmarking
Disk Setup
Memory for Database Caching
Server Configuration Tuning
Routine Maintenance
Database Benchmarking
Database Indexing
Query Optimization
Database Activity and Statistics
Monitoring and Trending
Pooling and Caching
Scaling with Replication
Partitioning Data
Database Profiling
Avoiding Common Problems
Performance Features by Release
Customer Reviews