Completed
Is SELECT * Expensive?
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
PostgreSQL
Automatically move to the next video in the Classroom when playback concludes
- 1 Connection Pooling in PostgresSQL with NodeJS (Performance Numbers)
- 2 Building a Web API with Express and PostgreSQL to Consume from Browser
- 3 Postgres Database Cursors in Python with psycopg2
- 4 Step by Step Javascript and Postgres Tutorial using node-postgres
- 5 Step-by-Step Python and Postgres Tutorial with psycopg2
- 6 Spinning multiple Postgres instances and PGAdmin with Docker
- 7 Database Sharding Crash Course (with Postgres examples)
- 8 Spinning a lightweight Postgres instance and Consume it with NodeJS
- 9 Enabling TLS/SSL on PostgreSQL with Docker
- 10 Database Partitioning Crash Course (with Postgres)
- 11 PostgreSQL 13 Has Some Performance Boosts! Let us discuss it!
- 12 Indexing in PostgreSQL vs MySQL
- 13 Be careful while working with large text fields in Postgres - TOAST
- 14 Postgres Instances hacked and used to mine crypto - Let us discuss how is that possible
- 15 Combining Database Indexes for Better Performance in Your Backend Applications (with PostgreSQL)
- 16 don’t use “offset” in your SQL
- 17 Burned by Docker and it was my fault
- 18 Bitmap Index Scan in Postgres Explained with Examples (Members only)
- 19 Create Postgres Table with a MILLION Rows (from scratch)
- 20 Create Index Blocking Production Database Writes? Postgres Solves this with this trick
- 21 Is SELECT * Expensive?
- 22 SELECT COUNT (*) can impact your Backend Application Performance, here is why
- 23 70GB of Unused Bloated Index Space Freed on Postgres, Here is how they did it
- 24 Serializable vs Repeatable Read Isolation Level - When to use one over the other in Database Systems
- 25 Explain Explained in PostgreSQL - How Databases Prepare Optimal Query Plans to Execute SQL
- 26 The New Postgres 14 Looks Promising - The Backend Engineering Show with Hussein Nasser
- 27 backend leaking Postgres database connections - what I did to fix it
- 28 The cost rolling back transactions (postgres/mysql)
