Optimizing PostgreSQL DB Queries with pgMustard - Talk Python to Me Ep.366

preview_player
Показать описание
Does your app have a database? Does that database play an important role in how the app operations and users perceive its quality? Most of you probably said yes to the first, and definitely to the second. But what if your DB isn't doing as well as it should? How would you know? And once you know, what do you do about it?

On this episode, we're joined by Michael Christofides, co-creator of pgMustard, to discuss and explore the EXPLAIN command for Postgres and other databases as well as all the recommendations you might dig into as a result of understanding exactly what's happening with you queries.

▬▬▬▬ About the podcast ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

▬▬▬▬ Guests ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

▬▬▬▬ Links and resources from the show ▬▬▬▬▬▬▬▬▬▬▬▬

▬▬▬▬ Dive deeper ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
  1. Talk Python
Рекомендации по теме
5 Secrets for 0:08:12

5 Secrets for making PostgreSQL run BLAZING FAST. How to improve database performance.

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Optimizing PostgreSQL DB 1:20:17

Optimizing PostgreSQL DB Queries with pgMustard - Talk Python to Me Ep.366

SQL Query Optimization 0:03:18

SQL Query Optimization - Tips for More Efficient Queries

Optimizing Queries in 0:44:51

Optimizing Queries in PostgreSQL with Giovanni Martinez, Tampa Bay PUG, October 25, 2021

SQL indexing best 0:04:08

SQL indexing best practices | How to make your database FASTER!

Query Optimization using 0:08:45

Query Optimization using PostgreSQL Profiler

SQL : How 0:01:20

SQL : How to optimize postgresql query with joins?

Connect Next.js to 0:22:40

Connect Next.js to Supabase: PostgreSQL & Prisma ORM Setup Guide

PostgreSQL performance tips 0:25:19

PostgreSQL performance tips you have never seen before | Citus Con: An Event for Postgres 2023

Understand PostgreSQL query 0:12:58

Understand PostgreSQL query plan in 10 minutes

102 Query optimization 0:36:36

102 Query optimization | Postgres.FM 014 | #PostgreSQL #Postgres podcast

5 Ways to 0:10:04

5 Ways to Improve Your SQL Queries

PostgreSql query optimizing 0:01:35

PostgreSql query optimizing demostration

PostgreSQL Query Optimization 0:51:12

PostgreSQL Query Optimization Techniques | Databases A2Z

Mostly mistaken and 0:33:11

Mostly mistaken and ignored parameters while optimizing a #PostgreSQL #database - #Percona Live 2020

Squeeze More Out 0:00:54

Squeeze More Out of Your PostgreSQL Database #postgresql #sql #database #programming

Databases: Optimizing PostgreSQL 0:02:35

Databases: Optimizing PostgreSQL query with multiple subqueries

How to optimize 0:01:46

How to optimize min/max queries for large tables on PostgreSQL?

How to optimize 0:03:05

How to optimize PostgreSQL query with multiple joins and subqueries and slow grouping/sorting?

Stephanie Mifsud - 0:30:48

Stephanie Mifsud - Optimizing queries for not so big data in PostgreSQL

Database Indexing Explained 0:18:19

Database Indexing Explained (with PostgreSQL)

PostgreSQL, performance for 0:30:45

PostgreSQL, performance for queries with grouping

Postgres Pulse: Using 0:31:45

Postgres Pulse: Using EXPLAIN ANALYZE for Planning and Optimizing Query Performance | PostgreSQL

Комментарии
Автор

A. Introduction 0:00

B. Opensource SQL Editors and Daatabase Managers
9:19 DBeaver
10:55 ArcType
12:39 Beekeeper Studio
13:19 DataGrip (jetbrains)
16:25 Postice (eagerapps)
17:53 pgMustard

C. PostgreSQL Tips and Tricks
22:10 Database Tips (Part-1)

D. Cool Tools (Shout Out)
32:11 Mockaroo (generate fake data)

E. PostgreSQL Tips and Tricks
39:10 Database Tips (Part-2)

F. PostgreSQL Helpful Resources (Shout Out)
53:30 explain-depesz
56:33 explain-dalibo
58:46 pgMustard (walkthrough)

SUGATORAY
Автор

I see you using Bing for your search. Are you using it so you can donate points to the PSF? 🙂

pdecker
Автор

Why can a database not do indexes itself based on index use, index usefulness and useful indexes that do not exist?

Superdooperhero