Scaling Postgres Episode 247 Generate Test Data, Faster Archiving, Date Statistics, Useless Indexes
Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss how to generate test data, how WAL archiving is faster in PG15, how to set date statistics on a timestamp and how to avoid useless indexes.
Content Discussed
- Generating lots of test data with Postgres, fast and faster
- Speed Up of the WAL Archiving in PostgreSQL 15
- Improving GROUP BY with CREATE STATISTICS
- Don't do this: creating useless indexes
- JSON logs in PostgreSQL 15
- PostgreSQL hidden gems
- Advent of Code 2022: Days 6-10 With PostgreSQL
- How to Solve Advent of Code 2022 Using Postgres - Day 6
- How to Solve Advent of Code 2022 Using Postgres - Day 7
- How to Solve Advent of Code 2022 Using Postgres - Day 8
- How to Solve Advent of Code 2022 Using Postgres - Day 9
- How to Solve Advent of Code 2022 Using Postgres - Day 10
- PGSQL Phriday #004: PostgreSQL and Software Development
- PGSQL Phriday #004: PostgreSQL and Software Development
- Database DevOps and Code management with PostgreSQL
- PGSQL Phriday #004: Sequence Survey
- Postgres and Software Development: PGSQL Phriday #004
- UNION ALL, data types and performance
- Speed up Postgres queries with UNIONs and subquery pull-up
- Transparent Data Encryption (TDE)
- pgsodium
- Diffing PostgreSQL Schema Changes
- PostgreSQL Vacuuming to Optimize Database Performance and Reclaim Space
- Oracle vs SQL Server vs PostgreSQL – DATE data type
- PostgreSQL 16: part 3 or CommitFest 2022-11
- Row estimates
- Postgres year in review 2022
- Transaction ID wraparound
- Lukas Eder
YouTube Video
