Mastering PostgreSQL 15 : advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications /

Starting with an introduction to the newly released features of PostgreSQL 15, this updated fifth edition will help you get to grips with PostgreSQL administration and how to build dynamic database solutions for enterprise apps, including designing both physical and technical aspects of the system....

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Schönig, Hans-Jürgen (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, UK : Packt Publishing Ltd., 2023.
Edición:5th edition.
Temas:
PostgreSQL.
PostgreSQL
SQL (Computer program language)
SQL (Langage de programmation)
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • Title Page
  • Copyright and Credits
  • Contributors
  • Table of Contents
  • Preface
  • Chapter 1: PostgreSQL 15 Overview
  • Making use of DBA-related features
  • Removing support for old pg_dump
  • Deprecating Python 2
  • Fixing the public schema
  • Adding pre-defined roles
  • Adding permissions to variables
  • Improving pg_stat_statements
  • New wait events
  • Adding logging functionality
  • Understanding developer-related features
  • Security invoker views
  • ICU locales
  • Better numeric
  • Handling ON DELETE
  • Working around NULL and UNIQUE
  • Adding the MERGE command to PostgreSQL
  • Using performance-related features
  • Adding multiple compression algorithms
  • Handling parallel queries more efficiently
  • Improved statistics handling
  • Prefetching during WAL recovery
  • Additional replication features
  • Two-phase commit for logical decoding
  • Adding row and column filtering
  • Improving ALTER SUBSCRIPTION
  • Supporting compressed base backups
  • Introducing archiving libraries
  • Summary
  • Chapter 2: Understanding Transactions and Locking
  • Working with PostgreSQL transactions
  • Handling errors inside a transaction
  • Making use of SAVEPOINT
  • Transactional DDLs
  • Understanding basic locking
  • Avoiding typical mistakes and explicit locking
  • Making use of FOR SHARE and FOR UPDATE
  • Understanding transaction isolation levels
  • Considering serializable snapshot isolation transactions
  • Observing deadlocks and similar issues
  • Utilizing advisory locks
  • Optimizing storage and managing cleanup
  • Configuring VACUUM and autovacuum
  • Watching VACUUM at work
  • Limiting transactions by making use of snapshot too old
  • Making use of more VACUUM features
  • Summary
  • Questions
  • Chapter 3: Making Use of Indexes
  • Understanding simple queries and the cost model
  • Making use of EXPLAIN
  • Digging into the PostgreSQL cost model
  • Deploying simple indexes
  • Making use of sorted output
  • Using bitmap scans effectively
  • Using indexes in an intelligent way
  • Understanding index de-duplication
  • Improving speed using clustered tables
  • Clustering tables
  • Making use of index-only scans
  • Understanding additional B-tree features
  • Combined indexes
  • Adding functional indexes
  • Reducing space consumption
  • Adding data while indexing
  • Introducing operator classes
  • Creating an operator class for a B-tree
  • Understanding PostgreSQL index types
  • Hash indexes
  • GiST indexes
  • GIN indexes
  • SP-GiST indexes
  • BRINs
  • Adding additional indexes
  • Achieving better answers with fuzzy searching
  • Taking advantage of pg_trgm
  • Speeding up LIKE queries
  • Handling regular expressions
  • Understanding full-text searches
  • Comparing strings
  • Defining GIN indexes
  • Debugging your search
  • Gathering word statistics
  • Taking advantage of exclusion operators
  • Summary
  • Questions
  • Chapter 4: Handling Advanced SQL
  • Supporting range types

Ejemplares similares