The Dangers of Temporary Tables | Scaling Postgres 349
Join Over 1,000 Engineers & Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss the dangers of temporary tables, better transparent data encryption, pig the extension wizard, and table level lock considerations.
Content Discussed
- What Hurts in PostgreSQL Part One: Temporary Tables
- Your Data’s Not Safe Until It’s TDE-Safe — Here’s How
- ANNOUNCE pig: The Postgres Extension Wizard
- Anatomy of Table-Level Locks in PostgreSQL
- pg_squeeze
- Waiting for PostgreSQL 18 – Support LIKE with nondeterministic collations
- Fix a top cause of slow queries in PostgreSQL (no slow query log needed)
- Postgres Tuning & Performance for Analytics Data
- Postgres Per-Connection Statistics
- Summary of PostgreSQL in 2024
- The power of open source in PostgreSQL
- Idle Transactions Cause Table Bloat? Wait, What?
- Cut Cloud Costs with Smarter PostgreSQL CPU Core Allocation
- Contributions for the week 51 (2024) and the week 2 (2025)
- PgPedia Week, 2025-01-12
- TimescaleDB in 2024: Making Postgres Faster
- Handling Billions of Rows in PostgreSQL
- What Is Semantic Search With Filters and How to Implement It With Pgvector and Python
- Semantic Search with OpenAI and PostgreSQL in 10 Minutes
- Test Your Database Without Mocks
- An API to Track Database Schema Changes
YouTube Video
Podcast Audio
