LIBRISTO
LIBROAMANTO
mandatory
Become part of a community of book lovers from all over the world and get access to a whole bunch of benefits. Create an account for free
0
Free delivery for purchases over 69.99 €
DPD courier 4.49 € DPD point 3.99 € GLS courier 5.49 € GLS point 4.49 € Croatian Post 5.49 € Overseas courier 5.49 € Box Now 4.99 €

Free delivery for orders over 69.99 euro

PostgreSQL Query Optimization

The Ultimate Guide to Building Efficient Queries

Language EnglishEnglish
E-book Adobe ePub DRM
Publishers Apress, April 2021
Write optimized queries. This book helps you write queries that perform fast and deliver results on... Full description
? points 177 b
72.39 €
christmas Christmas delivery ▾ In stock Immediate digital delivery


Customers also purchased


La comunicacion sin barreras Sandra Analia Cevey / E-book Adobe ePub DRM
common.buy 13.61 €
BAYA - RHAPSODIE ALGEROISE Aziz CHOUAKI / Book Paperback
common.buy 15.91 €
The Rise of Ancient Indians Vijender Sharma / Book Paperback
common.buy 18.72 €
Top
Menschen A1 Sabine Schlüter / Book Paperback
common.buy 10.60 €
25. Oktober, mein Geburtstag Andreas Kuhnemann / E-book Adobe ePub DRM
common.buy 5.30 €
Prision GPU Hassel / Audiobook MP3
common.buy 10.91 €
Una mujer no muere jamas Beni / Audiobook MP3
common.buy 10.91 €
Attitude Sheila Brody Audio Audio vinyl
common.buy 9.70 €
OpenSITEM Lilia Edith Aparicio Pico / E-book Adobe ePub DRM
common.buy 4.50 €
Pädagogin, Lehrerin und Forscherin Antonio Alanís Huerta / Book Paperback
common.buy 63.38 €
Nieuzasadnione poczucie szczęścia Tyczyński Tomasz / Book Paperback
common.buy 8.20 €
Das Marsprojekt (5). Die schlafenden Huter Andreas Eschbach / E-book Adobe ePub DRM
common.buy 8.30 €
Prenez le pouvoir ! Hulo Guillabert / E-book Adobe ePub DRM
common.buy 12.31 €
La fe de Bartholomew Roberts Jeremy McLean / E-book Adobe ePub DRM
common.buy 1.99 €
CAPRICCIO, ARIA AND FINALE HERMANN REUTTER Printed items Sheet music
common.buy 34.34 €
Secrets coquins de l'histoire de France Marc Pasteger / Book Paperback
common.buy 19.42 €
LA DAME DE JERUSALEM Dan Franck et Jean Vautrin / Book Paperback
common.buy 50.06 €
La aventura de innovar, el cambio en los centros educativos Jaume Carbonell Sebarroja / Book Paperback
common.buy 12.81 €
Bildung fuer nachhaltige Entwicklung Norbert Pütz / Book Hardback
common.buy 54.17 €
Brahms (for female choir) Kvindelige Studenters Sangforening / Audio Audio CD
common.buy 13.71 €
7th Symphony / Piano Concerto, 1 Audio-CD Erkki-Sven Tuur / Audio Audio CD
common.buy 22.82 €

Write optimized queries. This book helps you write queries that perform fast and deliver results on time. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers. Any motivated professional can learn to write efficient queries from the get-go and capably optimize existing queries. You will learn to look at the process of writing a query from the database engine's point of view, and know how to think like the database optimizer.The book begins with a discussion of what a performant system is and progresses to measuring performance and setting performance goals. It introduces different classes of queries and optimization techniques suitable to each, such as the use of indexes and specific join algorithms. You will learn to read and understand query execution plans along with techniques for influencing those plans for better performance. The book also covers advanced topics such as the use of functions and procedures, dynamic SQL, and generated queries. All of these techniques are then used together to produce performant applications, avoiding the pitfalls of object-relational mappers.What You Will LearnIdentify optimization goals in OLTP and OLAP systemsRead and understand PostgreSQL execution plansDistinguish between short queries and long queriesChoose the right optimization technique for each query typeIdentify indexes that will improve query performanceOptimize full table scansAvoid the pitfalls of object-relational mapping systemsOptimize the entire application rather than just database queries Who This Book Is ForIT professionals working in PostgreSQL who want to develop performant and scalable applications, anyone whose job title contains the words "e;database developer"e; or "e;database administrator"e; or who is a backend developer charged with programming database calls, and system architects involved in the overall design of application systems running against a PostgreSQL database

Actress & Polyglot
EWA KASP for
Play video
Ewa Kasp
Libristo has the largest selection of foreign-language books. That’s why I buy my books there.

About the book

Full name PostgreSQL Query Optimization
Language English
Binding E-book - Adobe ePub DRM
Date of issue 2021
EAN 9781484268858
Libristo code 40410960
Publishers Apress
Give this book today
It's easy
1 Add to cart and choose Deliver as present at the checkout 2 We'll send you a voucher 3 The book will arrive at the recipient's address

You might also be interested in


Oh Dear Silvia Dawn French / Audiobook MP3
common.buy 8.70 €
Athenian Year Benjamin D. Meritt / Book Hardback
common.buy 95.13 €
Margaret Thatcher. Between Icon and Hate Figure Sebastian Nickel / Book Paperback
common.buy 15.11 €
Dress Up Mix And Match for Girls Jupiter Kids / Book Paperback
common.buy 15.31 €
Quain's Elements of Anatomy William Sharpey / Book Paperback
common.buy 32.14 €
Remembering Genocides in Central Africa Rene Lemarchand / Book Hardback
common.buy 248.65 €
Business Result: Advanced: Class Audio CD Kate Baade / Audio Audio CD
common.buy 26.23 €
Federated Learning Systems Muhammad Habib ur Rehman / Book Paperback
common.buy 173.14 €
Nonreligious Lifeworlds in Egypt Karin van Nieuwkerk / E-book Adobe ePub DRM
common.buy 81.81 €
Traveling Texts and the Work of Afro-Japanese Cultural Production William H. Bridges IV / E-book Adobe ePub DRM
common.buy 53.47 €
Sacred Geometry for Artists, Dreamers, and Philosophers John Oscar Lieben / E-book Adobe ePub DRM
common.buy 28.23 €
New History of the Picts Stuart McHardy / E-book Adobe ePub DRM
common.buy 8.70 €
Harnessing Digitization for Remittances in Asia and the Pacific Asian Development Bank / E-book Adobe ePub DRM
common.buy 4.90 €
Protein Structure, Stability, and Folding Kenneth P. Murphy / E-book Adobe ePub DRM
common.buy 117.76 €
Dancehall : The Rise of Jamaican Dancehall Culture LESSER BETH/BAKER ST / Book Paperback
common.buy 41.75 €
Stuck! the Story of the La Brea Tar Pits Valerya Milovanova / Book Hardback
common.buy 15.31 €
The Northman / Video Blu-ray
common.buy 23.32 €
Between God and Tsar Isolde Thyret / Book Hardback
common.buy 63.68 €

Login

Log in to your account. Don't have a Libristo account? Create one now!

 
mandatory
mandatory

Don’t have an account? Discover the benefits of having a Libristo account!

With a Libristo account, you'll have everything under control.

Create a Libristo account
Book advisor Libroamiko
Hi, I'm Libroamiko, can I help?