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
• 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; 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.
• 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.