Descriptions
Ludicrous Speed Postgres, Forget lightspeed. You need ludicrous speed. If you have put off learning how to optimize your Postgres database because you thought it would take too long or would be too hard, wait no more. I designed this course to be the most efficient way to turn you into a Postgres performance master. Whether you need to optimize certain areas of your application or want to drop your overall database utilization, this course can help.
This comprehensive course covers optimization framework, btree indexes, vacuum and analyze, data types and index types, text and JSON search, advanced SQL techniques, data modification optimization, and advanced data handling solutions like partitioning and materialized views.
What you’ll learn
- Gain big data experience with multi-terabyte databases and billions of rows
- Acquire a toolkit for finding 10X, 100X or even 1,000X performance gains
- Learn cost reduction techniques to defer database upgrades or downgrade DB
- Master an optimization framework and thought processes for performance challenges
- Understand benchmarking guidelines and validation techniques
- Build confidence in Postgres optimization and become the hero of your team
Who this course is for
- Senior developers who want to leverage Postgres database optimization or take their knowledge to the next level
- Junior developers who use Postgres and want to leap frog fellow developers in performance optimization
- Database administrators (even accidental ones) who need advice on schema changes, index selection and statement usage
- Developers working with multi-terabyte databases with billions of rows who need optimization methods
Specificatoin of Ludicrous Speed Postgres
- Publisher : Scaling Postgres
- Teacher : Creston Jamison
- Language : English
- Level : All Levels
- Number of Course : 63
- Duration : 11 hours and 41 minutes
Content of Ludicrous Speed Postgres
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
Pictures
Sample Clip
Installation Guide
Extract the files and watch with your favorite player
Subtitle : Not Available
Quality: 1080p
Download Links
Downloadly
Rapidgator
Password file(s): www.downloadly.ir
File size
2.19 GB
