Cargando…
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....
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Publishing Ltd.,
2023.
|
| Edición: | 5th edition. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a22000007i 4500 | ||
|---|---|---|---|
| 001 | OR_on1369066038 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu|||unuuu | ||
| 008 | 230207s2023 enka o 001 0 eng d | ||
| 040 | |a ORMDA |b eng |e rda |e pn |c ORMDA |d EBLCP |d OCLCQ |d OCLCF |d OCLCQ |d OCLCO | ||
| 019 | |a 1369639143 |a 1369662908 |a 1373345232 | ||
| 020 | |z 9781803248349 | ||
| 020 | |a 9781803233949 | ||
| 020 | |a 180323394X | ||
| 029 | 1 | |a AU@ |b 000073554667 | |
| 035 | |a (OCoLC)1369066038 |z (OCoLC)1369639143 |z (OCoLC)1369662908 |z (OCoLC)1373345232 | ||
| 037 | |a 9781803248349 |b O'Reilly Media | ||
| 050 | 4 | |a QA76.9.D3 | |
| 082 | 0 | 4 | |a 005.74 |2 23/eng/20230207 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Schönig, Hans-Jürgen, |e author. | |
| 245 | 1 | 0 | |a Mastering PostgreSQL 15 : |b advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications / |c Hans-Jürgen Schönig. |
| 250 | |a 5th edition. | ||
| 264 | 1 | |a Birmingham, UK : |b Packt Publishing Ltd., |c 2023. | |
| 300 | |a 1 online resource (522 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 500 | |a Includes index. | ||
| 520 | |a 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. You'll explore advanced PostgreSQL features, such as logical replication, database clusters, advanced indexing, and user management to manage and maintain your database. You'll then work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and move from Oracle to PostgreSQL. Among the other skills that the book will help you build, you'll cover transactions, handling recursions, working with JSON and JSONB data, and setting up a Patroni cluster. It will show you how to improve performance with query optimization. You'll also focus on managing network security and work with backups and replication while exploring useful PostgreSQL extensions that optimize the performance of large databases. By the end of this PostgreSQL book, you'll be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease. | ||
| 505 | 0 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a PostgreSQL. |
| 630 | 0 | 7 | |a PostgreSQL |2 fast |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Schönig, Hans-Jürgen |t Mastering PostgreSQL 15 |d Birmingham : Packt Publishing, Limited,c2023 |z 9781803248349 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781803248349/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL30364131 | ||
| 994 | |a 92 |b IZTAP | ||