Mastering PostgreSQL 17 cover

Mastering PostgreSQL 17

Elevate your database skills with advanced deployment, optimization, and security strategies

by Hans-Jürgen Schönig

Price৳ 680
Price৳ 680

Have a question? Ask on WhatsApp or Message on Messenger

Call 01963 822422 / 01817 506044 for help with your order

Mastering PostgreSQL 17 by Hans-Jürgen Schönig is an advanced guide to database tuning, architecture, and high availability with PostgreSQL 17. It explores storage engine mechanics, query planner optimizations, and enterprise scaling strategies. The book delivers actionable guidance for managing vacuuming, concurrency locks, partitioned tables, and replication topologies.

What you will learn

  • Analyze query plans and cost estimates using EXPLAIN ANALYZE to identify scan and join bottlenecks
  • Fine-tune table indexing strategies including B-Tree, GiST, GIN, and BRIN indexes
  • Manage transactions, Multi-Version Concurrency Control (MVCC), and lock contention under high concurrency
  • Configure declarative table partitioning, logical replication, and connection pooling for scaling
  • Write high-performance stored procedures and integrate server extensions like PostGIS and pg_trgm
  • Implement autovacuum tuning, Write-Ahead Log (WAL) parameters, and robust disaster recovery workflows

Who this is for

Senior database administrators, backend architects, and data engineers responsible for enterprise PostgreSQL systems. Solid knowledge of SQL querying and fundamental database administration is recommended. Deep internals knowledge is not required.