Postgresql 18 engineering & reference (10 résultats)

PAP. Etat : New. New Book. Shipped from UK. Established seller since 2000.

PAP. Etat : New. New Book. Shipped from UK. Established seller since 2000.

PAP. Etat : New. New Book. Shipped from UK. Established seller since 2000.

PAP. Etat : New. New Book. Shipped from UK. Established seller since 2000.

Etat : New. Print on Demand.

Paperback. Etat : new. Paperback. Are you managing PostgreSQL clusters that span multiple servers, regions, and cloud environments, and finding that most books stop exactly where your real problems begin? Have you ever needed a single reference that covers not just how replication works, but what to do when it breaks at 2 a.m., how to measure the performance impact before your users notice it, and how to secure the entire stack so it meets compliance requirements your auditors will actually accept? This is that book. PostgreSQL 18 Deep Reference Manual Volume 2 picks up where foundational database knowledge ends and takes you directly into the engineering decisions that define whether a production PostgreSQL system survives at scale. This volume is built for engineers who already understand the basics and need precise, unambiguous answers to hard operational questions. What you will find inside: Performance engineering coverage that goes beyond tips and tricks, walking through the complete pg_stat family of views, wait event diagnosis, connection pooling internals, vacuum cost management, index bloat remediation, and hardware-level tuning for CPU, storage, and cloud-managed environments. A complete high availability and backup reference covering RTO and RPO design, pg_basebackup internals, native incremental backup introduced in PostgreSQL 18, WAL-based point-in-time recovery procedures, pgBackRest parallel restore architecture, Patroni DCS integration, HAProxy routing, and disaster recovery runbooks for real production failure scenarios. Deep application-layer coverage including wire protocol internals, driver behavior across psycopg3, asyncpg, node-postgres and pgx, ORM anti-patterns that silently destroy performance, prepared statement mechanics, COPY protocol optimization, and event-driven architecture with logical replication consumers. Advanced workload chapters on analytical and hybrid OLAP patterns, columnar storage extensions, vector search with pgvector for AI and machine learning applications, RAG pipeline architecture, hybrid full-text and vector search, distributed PostgreSQL with Citus, and multi-region write trade-offs. A rigorous security chapter covering role hierarchies, SCRAM-SHA-256 internals, SSL/TLS configuration, row-level and column-level security, pgaudit compliance logging, encryption at rest, privilege escalation paths, and hardening for CIS and PCI-DSS requirements. Operational engineering for teams running PostgreSQL at scale, including zero-downtime schema migrations, Kubernetes deployments with CloudNativePG, Prometheus observability stacks, and ten incident response runbooks for the most common production failures. If your PostgreSQL systems have outgrown introductory documentation, this is the engineering reference built for where you are now. This item is printed on demand. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.…

Etat : New. Print on Demand.

Paperback. Etat : new. Paperback. Are you tired of database documentation that explains what a command does but never tells you why it works that way? Have you ever hit a wall trying to understand why your queries slow down at scale, why autovacuum seems to fall behind, or why a replication setup that worked in testing falls apart in production? This book was written for engineers who are done with surface-level tutorials. PostgreSQL 18 Deep Reference Manual is a complete, no-filler technical reference covering the architecture, internals, and real-world engineering practices behind modern PostgreSQL. Across 24 chapters, it walks through the database engine from the inside out: process architecture, memory management, MVCC and transaction internals, write-ahead logging, storage layout, indexing theory, and query planning, all explained with the kind of depth that lets you reason about behavior instead of memorizing commands. But this is not a theory-only book. It is built for people who run PostgreSQL in production. You will find detailed, practical coverage of replication and high availability, partitioning strategy, stored procedures and server-side programming, extension development, performance engineering, backup and disaster recovery, security hardening, and operational practices for running PostgreSQL at scale. Newer capabilities introduced in PostgreSQL 18 are covered in depth, including native incremental backup, completed SQL/JSON functionality, virtual generated columns, asynchronous I/O architecture, and authentication enhancements. Modern workloads get dedicated attention too. There are full chapters on vector search and embedding storage for AI and machine learning applications, analytical and hybrid OLAP patterns, distributed PostgreSQL architectures, and the consensus mechanisms that keep clustered deployments consistent. For engineers who want to go further, there is a complete section on PostgreSQL internals for extension and core development: executor internals, custom access methods, background workers, hooks, and the process for contributing to the project itself. Every chapter is written as a serious technical reference, not a casual walkthrough. Code examples are labeled by language and grounded in real engineering scenarios rather than toy demonstrations. The back matter includes a full system catalog reference, a complete configuration parameter index, a wait event reference, an error code guide, a glossary of essential terms, and dozens of diagnostic queries DBAs actually use. So who is this book for? If you are a backend engineer, database administrator, site reliability engineer, or anyone responsible for keeping a PostgreSQL system fast, available, and secure, this manual is built to sit beside you at your desk, not collect dust on a shelf. Whether you are troubleshooting a production incident at 2 a.m. or designing a new system from scratch, this is the reference that explains the reasoning behind the behavior, not just the syntax. If you have ever wanted a single resource that respects your time and your intelligence, this is it. This item is printed on demand. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.…

Paperback. Etat : new. Paperback. Are you managing PostgreSQL clusters that span multiple servers, regions, and cloud environments, and finding that most books stop exactly where your real problems begin? Have you ever needed a single reference that covers not just how replication works, but what to do when it breaks at 2 a.m., how to measure the performance impact before your users notice it, and how to secure the entire stack so it meets compliance requirements your auditors will actually accept? This is that book. PostgreSQL 18 Deep Reference Manual Volume 2 picks up where foundational database knowledge ends and takes you directly into the engineering decisions that define whether a production PostgreSQL system survives at scale. This volume is built for engineers who already understand the basics and need precise, unambiguous answers to hard operational questions. What you will find inside: Performance engineering coverage that goes beyond tips and tricks, walking through the complete pg_stat family of views, wait event diagnosis, connection pooling internals, vacuum cost management, index bloat remediation, and hardware-level tuning for CPU, storage, and cloud-managed environments. A complete high availability and backup reference covering RTO and RPO design, pg_basebackup internals, native incremental backup introduced in PostgreSQL 18, WAL-based point-in-time recovery procedures, pgBackRest parallel restore architecture, Patroni DCS integration, HAProxy routing, and disaster recovery runbooks for real production failure scenarios. Deep application-layer coverage including wire protocol internals, driver behavior across psycopg3, asyncpg, node-postgres and pgx, ORM anti-patterns that silently destroy performance, prepared statement mechanics, COPY protocol optimization, and event-driven architecture with logical replication consumers. Advanced workload chapters on analytical and hybrid OLAP patterns, columnar storage extensions, vector search with pgvector for AI and machine learning applications, RAG pipeline architecture, hybrid full-text and vector search, distributed PostgreSQL with Citus, and multi-region write trade-offs. A rigorous security chapter covering role hierarchies, SCRAM-SHA-256 internals, SSL/TLS configuration, row-level and column-level security, pgaudit compliance logging, encryption at rest, privilege escalation paths, and hardening for CIS and PCI-DSS requirements. Operational engineering for teams running PostgreSQL at scale, including zero-downtime schema migrations, Kubernetes deployments with CloudNativePG, Prometheus observability stacks, and ten incident response runbooks for the most common production failures. If your PostgreSQL systems have outgrown introductory documentation, this is the engineering reference built for where you are now. This item is printed on demand. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.…

Paperback. Etat : new. Paperback. Are you tired of database documentation that explains what a command does but never tells you why it works that way? Have you ever hit a wall trying to understand why your queries slow down at scale, why autovacuum seems to fall behind, or why a replication setup that worked in testing falls apart in production? This book was written for engineers who are done with surface-level tutorials. PostgreSQL 18 Deep Reference Manual is a complete, no-filler technical reference covering the architecture, internals, and real-world engineering practices behind modern PostgreSQL. Across 24 chapters, it walks through the database engine from the inside out: process architecture, memory management, MVCC and transaction internals, write-ahead logging, storage layout, indexing theory, and query planning, all explained with the kind of depth that lets you reason about behavior instead of memorizing commands. But this is not a theory-only book. It is built for people who run PostgreSQL in production. You will find detailed, practical coverage of replication and high availability, partitioning strategy, stored procedures and server-side programming, extension development, performance engineering, backup and disaster recovery, security hardening, and operational practices for running PostgreSQL at scale. Newer capabilities introduced in PostgreSQL 18 are covered in depth, including native incremental backup, completed SQL/JSON functionality, virtual generated columns, asynchronous I/O architecture, and authentication enhancements. Modern workloads get dedicated attention too. There are full chapters on vector search and embedding storage for AI and machine learning applications, analytical and hybrid OLAP patterns, distributed PostgreSQL architectures, and the consensus mechanisms that keep clustered deployments consistent. For engineers who want to go further, there is a complete section on PostgreSQL internals for extension and core development: executor internals, custom access methods, background workers, hooks, and the process for contributing to the project itself. Every chapter is written as a serious technical reference, not a casual walkthrough. Code examples are labeled by language and grounded in real engineering scenarios rather than toy demonstrations. The back matter includes a full system catalog reference, a complete configuration parameter index, a wait event reference, an error code guide, a glossary of essential terms, and dozens of diagnostic queries DBAs actually use. So who is this book for? If you are a backend engineer, database administrator, site reliability engineer, or anyone responsible for keeping a PostgreSQL system fast, available, and secure, this manual is built to sit beside you at your desk, not collect dust on a shelf. Whether you are troubleshooting a production incident at 2 a.m. or designing a new system from scratch, this is the reference that explains the reasoning behind the behavior, not just the syntax. If you have ever wanted a single resource that respects your time and your intelligence, this is it. This item is printed on demand. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.…