Cargando…
Mastering PostgreSQL 9.6 : a comprehensive guide for PostgreSQL 9.6 developers and administrators /
Master the capabilities of PostgreSQL 9.6 to efficiently manage and maintain your database About This Book Your one-stop guide to mastering the advanced concepts in PostgreSQL with ease Master query optimization, replication, and high availability with PostgreSQL Extend the functionalities of Postgr...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Publishing,
2017.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Customer Feedback; Table of Contents; Preface; Chapter 1: PostgreSQL Overview; What is new in PostgreSQL 9.6?; Understanding new database administration functions; Killing idle sessions; Finding more detailed information in pg_stat_activity; Tracking vaccum progress; Improving vacuum speed; Digging into new SQL and developer-related functions; Using new backup and replication functionality; Streamlining wal_level and monitoring; Using multiple synchronous standby servers.
- Understanding performance-related featuresImproving relation extensions; Checkpoint sorting and kernel interaction; Using more advanced foreign data wrappers; Introducing parallel queries; Adding snapshot too old; Summary; Chapter 2: Understanding Transactions and Locking; Working with PostgreSQL transactions; Handling errors inside a transaction; Making use of savepoints; Transactional DDLs; Understanding basic locking; Avoiding typical mistakes and explicit locking; Considering alternative solutions; Making use of FOR SHARE and FOR UPDATE; Understanding transaction isolation levels.
- Considering SSI transactionsObserving deadlocks and similar issues; Utilizing advisory locks; Optimizing storage and managing cleanup; Configuring VACUUM and autovacuum; Digging into transaction wraparound-related issues; A word on VACUUM FULL; Watching VACUUM at work; Making use of snapshot too old; Summary; 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 more than one index at a time; Using bitmap scans effectively.
- Using indexes in an intelligent wayImproving 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; Hacking up an operator class for a B-tree; Creating new operators; Creating operator classes; Testing custom operator classes; Understanding PostgreSQL index types; Hash indexes; GiST indexes; Understanding how GiST works; Extending GiST; GIN indexes; Extending GIN; SP-GiST indexes; BRIN indexes.
- Extending BRIN indexesAdding additional indexes; Achieving better answers with fuzzy searching; Taking advantage of pg_trgm; Speed up LIKE queries; Handling regular expressions; Understanding full-text search
- FTS; Comparing strings; Defining GIN indexes; Debugging your search; Gathering word statistics; Taking advantage of exclusion operators; Summary; Chapter 4: Handling Advanced SQL; Introducing grouping sets; Loading some sample data; Applying grouping sets; Investigating performance; Combining grouping sets with the FILTER clause; Making use of ordered sets.