Mastering PostgreSQL 11 : Expert Techniques to Build Scalable, Reliable, and Fault-Tolerant Database Applications, 2nd Edition.
This book includes the newly introduced features in PostgreSQL 11, and shows you how to build better PostgreSQL applications, and administer your PostgreSQL database efficiently. You will master the advanced features of PostgreSQL and acquire the necessary skills to build efficient database solution...
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham :
Packt Publishing Ltd,
2018.
|
| Edition: | 2nd ed. |
| Subjects: | |
| Online Access: |
Full text (Emmanuel users only) |
MARC
| LEADER | 00000cam a2200000ui 4500 | ||
|---|---|---|---|
| 001 | in00000153376 | ||
| 006 | m o d | ||
| 007 | cr |n|---||||| | ||
| 008 | 190216s2018 enk o 000 0 eng d | ||
| 005 | 20240702202740.7 | ||
| 020 | |a 9781789539172 | ||
| 020 | |a 178953917X | ||
| 035 | |a (OCoLC)1086122778 | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d MERUC |d CHVBK |d OCLCO |d UKAHL |d OCLCF |d OCLCQ |d OCLCO |d OCLCQ |d NLW |d OCLCO |d OCLCQ |d OCLCO |d OCLCQ |d OCLCL | ||
| 050 | 4 | |a QA76.9.D3 |b S36 2018 | |
| 082 | 0 | 4 | |a 005.7565 |q OCoLC |2 23/eng/20231120 |
| 100 | 1 | |a Schönig, Hans-Jürgen. | |
| 245 | 1 | 0 | |a Mastering PostgreSQL 11 : |b Expert Techniques to Build Scalable, Reliable, and Fault-Tolerant Database Applications, 2nd Edition. |
| 250 | |a 2nd ed. | ||
| 260 | |a Birmingham : |b Packt Publishing Ltd, |c 2018. | ||
| 300 | |a 1 online resource (438 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 500 | |a Ordering data inside a window | ||
| 505 | 0 | |a Cover; Title Page; Copyright and Credits; About Packt; Contributors; Table of Contents; Preface; Chapter 1: PostgreSQL Overview; What is new in PostgreSQL 11.0?; Understanding the new database administration functions; Using configurable WAL-segment sizes; Larger queryid in pg_stat_statements; Improved indexing and better optimization; Expression index statistics; INCLUDE indexes or covering indexes; Parallel index creation; Better cache management; Improving pg_prewarm; Enhancing windowing functions; Introducing just-in-time compilation; Enhanced partitioning | |
| 505 | 8 | |a Adding support for stored proceduresImproving ALTER TABLE; Summary; Questions; 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; Considering alternative solutions; Making use of FOR SHARE and FOR UPDATE; Understanding transaction isolation levels; Considering SSI transactions; Observing deadlocks and similar issues; Utilizing advisory locks; Optimizing storage and managing cleanup | |
| 505 | 8 | |a Configuring VACUUM and autovacuumDigging into transaction wraparound-related issues; A word on VACUUM FULL; Watching VACUUM at work; Limiting transactions by making use of snapshot too old; 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 more than one index at a time; Using bitmap scans effectively; Using indexes in an intelligent way; Improving speed using clustered tables; Clustering tables | |
| 505 | 8 | |a Making use of index-only scansUnderstanding additional btree features; Combined indexes; Adding functional indexes; Reducing space consumption; Adding data while indexing; Introducing operator classes; Hacking up an operator class for a btree; 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 indexes; Adding additional indexes; Achieving better answers with fuzzy searching | |
| 505 | 8 | |a Taking advantage of pg_trgmSpeeding up LIKE queries; Handling regular expressions; Understanding full-text search; Comparing strings; Defining GIN indexes; Debugging your search; Gathering word statistics; Taking advantage of exclusion operators; Summary; Questions; 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; Understanding hypothetical aggregates; Utilizing windowing functions and analytics; Partitioning data | |
| 520 | |a This book includes the newly introduced features in PostgreSQL 11, and shows you how to build better PostgreSQL applications, and administer your PostgreSQL database efficiently. You will master the advanced features of PostgreSQL and acquire the necessary skills to build efficient database solutions. | ||
| 588 | 0 | |a Print version record. | |
| 630 | 0 | 0 | |a PostgreSQL. |
| 650 | 0 | |a Database management. | |
| 758 | |i has work: |a Mastering PostgreSQL 11 (Text) |1 https://id.oclc.org/worldcat/entity/E39PCFrkQxGmW43XHCjvJWX7h3 |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Schönig, Hans-Jürgen. |t Mastering PostgreSQL 11 : Expert Techniques to Build Scalable, Reliable, and Fault-Tolerant Database Applications, 2nd Edition. |d Birmingham : Packt Publishing Ltd, ©2018 |z 9781789537819 |
| 852 | |b Online |h ProQuest | ||
| 856 | 4 | 0 | |u https://ebookcentral.proquest.com/lib/emmanuel/detail.action?docID=5675781 |z Full text (Emmanuel users only) |t 0 |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH35401000 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL5675781 | ||
| 947 | |a FLO |x pq-ebc-base | ||
| 999 | f | f | |s e082b22a-b51a-4a42-8ac8-158b23efe4f8 |i 79f0828d-e6ce-431a-8d7b-9387c92d84b1 |t 0 |
| 952 | f | f | |a Emmanuel College |b Main Campus |c Emmanuel College Library |d Online |t 0 |e ProQuest |h Other scheme |
| 856 | 4 | 0 | |t 0 |u https://ebookcentral.proquest.com/lib/emmanuel/detail.action?docID=5675781 |y Full text (Emmanuel users only) |