PostgreSQL query optimization the ultimate guide to building efficient queries / Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova.
| Author/creator | Dombrovskaya, Henrietta author. |
| Other author | Novikov, Boris, author. |
| Other author | Bailliekova, Anna, author. |
| Format | Book |
| Publication | New York : Apress, [2021] |
| Copyright Date | ©2021 |
| Description | xxiii, 319 pages : illustrations ; 26 cm |
| Subjects |
| Contents | Introduction -- Chapter 1: Why optimize? -- Chapter 2: Theory: yes, we need it! -- Chapter 3: Even more theory: algorithms -- Chapter 4: Understanding execution plan -- Chapter 5: Short queries and indexes -- Chapter 6: Long queries and full scans -- Chapter 7: Long queries: additional techniques -- Chapter 8: Optimizing data modification -- Chapter 9: Design matters -- Chapter 10: Application development and performance -- Chapter 11: Functions -- Chapter 12: Dynamic SQL -- Chapter 13: Avoiding the pitfalls of object-relational mapping -- Chapter 14: More complex filtering and search -- Chapter 15: Ultimate optimization algorithm -- Chapter 16: Conclusion. |
| General note | Includes index. |
| ISBN | 9781484268841 paperback |
| ISBN | 1484268849 paperback |
Availability
| Library | Location | Call Number | Status | Item Actions |
|---|---|---|---|---|
| Joyner | General Stacks | QA76.9 .D3 2021 | ✔ Available | Place Hold |