Skip to content Skip to sidebar Skip to footer

Ludicrous Speed Postgres

Ludicrous Speed Postgres

English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 63 Lessons (11h 41m) | 2.30 GB

 

This course is dedicated to optimizing PostgreSQL performance with a focus on competent schema design and effective database usage. It is designed for those who want to quickly and practically master techniques for accelerating Postgres performance, from local improvements to reducing the overall load on the system.

The course is suitable for senior developers who want to explore the capabilities of Postgres in greater depth and achieve impressive query speedups; junior developers who want to get ahead in understanding how to optimize working with large data sets; and database administrators who need to reduce the load on the processor and disks by choosing the right indexes, schemas, and queries.

You will learn how to work with multi-terabyte databases containing billions of rows, master optimization frameworks and benchmarking techniques, and acquire a set of tools for accelerating performance (up to 1000x) and reducing infrastructure costs. By the end of the course, you will be confident in approaching optimization tasks and will become someone who brings tangible results and real victories to the team.

1 Welcome!
2 psql Intro
3 pg_stat_statements Intro
4 Explain Intro
5 Intro & Mindset
6 Optimization Framework
7 Do Less Work
8 Robbing Peter To Pay Paul
9 Course Database
10 Course Database Configuration
11 Intro & Finding Large Data
12 Multi-Column Indexes
13 Ordering With Btree Indexes
14 Partial Indexes
15 Expression Indexes
16 Index-Only Scans & Covering Indexes
17 Index Costs
18 Intro
19 Vacuum
20 Statistics & Analyze
21 Extended Statistics
22 Reindexing
23 Remove Unused Indexes
24 Intro
25 Data Type Decisions
26 Array Data Types
27 GIN Indexes
28 Range Data Types
29 GIST Indexes
30 BRIN Indexes
31 Hash Indexes
32 Intro
33 Btree Text Search
34 Basic Full-Text Search
35 Advanced Full-Text Search
36 Fuzzy / Similar / Partial Text Search
37 JSONB Search
38 Intro
39 Distinct On
40 Lateral Joins
41 Union, Intersect, Except
42 CTE & Materialized
43 Paging & Keyset Pagination
44 User Prefix Search Feature
45 Intro
46 General Guidance
47 Too Many Inserts
48 Too Many Updates
49 Too Many Deletes
50 Bulk Loading
51 Intro
52 Partitioning
53 Materialized Views
54 Summary Tables & Real-Time Aggregates
55 Q & A #1 2/29/2024
56 Q & A #2 3/11/2024
57 Q & A #3 3/18/2024
58 Q & A #4 3/25/2024
59 Q & A #5 4/1/2024
60 Q & A #6 4/8/2024
61 Q & A #7 4/15/2024
62 Q & A #8 4/22/2024
63 Q & A 6/10/2024

LUDEIACODIEUSAPERRAEDEFPOSTAGERFRA


Password
HUuYjH666KIujjHyHg4

you must be registered member to see linkes Register Now

Leave a comment