Mastering PostgreSQL 9.6 : a comprehensive guide for PostgreSQL 9.6 developers and administrators /: a comprehensive guide for PostgreSQL 9.6 developers and administrators. (2017)
- Record Type:
- Book
- Title:
- Mastering PostgreSQL 9.6 : a comprehensive guide for PostgreSQL 9.6 developers and administrators /: a comprehensive guide for PostgreSQL 9.6 developers and administrators. (2017)
- Main Title:
- Mastering PostgreSQL 9.6 : a comprehensive guide for PostgreSQL 9.6 developers and administrators
- Further Information:
- Note: Hans-Jurgen Schonig.
- Other Names:
- Schönig, Hans-Jürgen
- Contents:
- 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;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. … (more)
- Publisher Details:
- Birmingham : Packt Publishing
- Publication Date:
- 2017
- Extent:
- 1 online resource (408)
- Subjects:
- 005.74
COMPUTERS -- Databases -- General
Database management
Database management
COMPUTERS -- Databases -- Servers
COMPUTERS -- Data Processing
Electronic books - Languages:
- English
- ISBNs:
- 9781783555369
- Related ISBNs:
- 178355536X
- Notes:
- Note: Print version record.
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.170055
- Ingest File:
- 01_121.xml