Talk Python To Me

#366: Optimizing PostgreSQL DB Queries with pgMustard

May 20, 2022
Ask episode
Chapters
Transcript
Episode notes
1
Introduction
00:00 • 3min
2
Postgres Data Bases
02:54 • 2min
3
How Did You Get Into Data Bases?
04:51 • 2min
4
Data Bases - What's the Difference?
07:14 • 2min
5
How to Optimize Data Bases?
08:54 • 3min
6
PostgreSQL
11:57 • 2min
7
Is Data Grip a Good Tool?
13:50 • 2min
8
What's the Most Powerful Utility of Picequa?
15:52 • 2min
9
How to Remove Stress From Your Life With Sentry
17:24 • 3min
10
What Can You Do About It?
20:32 • 2min
11
How to Find Problems With Your Data Base
22:12 • 2min
12
Why Is It Slow?
23:46 • 2min
13
How to Add Io Information to a Query in Postgress?
25:55 • 3min
14
Is PostGrass Local or Local a Good Idea?
28:29 • 2min
15
How to Generate Fake Data?
30:30 • 2min
16
PostgreSQL - Can a Multicula Bit Blot Blobs Be Used?
32:10 • 2min
17
Using Mongo to Outperform Postgrests
34:02 • 2min
18
Can I Run This, Can I Analyze My Local Machine?
35:54 • 2min
19
Is There a Problem With Post Grint?
37:58 • 2min
20
Post Grass Query Plans - What You Need to Know
39:54 • 3min
21
The Biggest Thing to Do on Postgress Is to Work Out Where the Time Is Going
42:42 • 2min
22
The Query Is Not Returning 200 Thousand Rows, Is It?
44:45 • 3min
23
The Knock on Effects of Passing That Many Columns
47:24 • 3min
24
Using a Post Grithms Tool to High Light in Red
50:00 • 2min
25
The Queer Planet, a Visual Visualization of the Queer World.
52:04 • 2min
26
Query Plan
53:51 • 2min
27
The Most Valuable Operations on Disks
55:41 • 3min
28
How to Rebuild an Index?
58:25 • 2min
29
How to Get the Most Out of a Timer
01:00:34 • 2min
30
Is There a Better Way to Estimate Joins?
01:02:50 • 2min
31
PostgreSQL
01:04:21 • 2min
32
Index Potential Tip
01:06:13 • 2min
33
Is It Worth Taking a Look?
01:07:51 • 2min
34
The Best Data Base Goe Tool Ever?
01:10:19 • 2min
35
Talk Python - How to Get Started on Talk Python
01:11:50 • 2min