How to Load a DB Without Load Testing During a Migration to PostgreSQL
summary
Discusses migrating databases to PostgreSQL when conventional load testing isn’t available, outlining risks from lack of ready load tests and techniques to assess PostgreSQL performance without full-scale load tests. Covers specific methods and approaches for estimating behavior and bottlenecks during migration, and contrasts those with problems of traditional load testing.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 3:24Performance testing issues
- 10:09Query data collection in PostgreSQL
- 13:43App-side data collection
- 17:58Load test prep
- 22:33Migration test results
- 28:10Problem analysis and fixes
- 31:19Conclusion and recommendations
- 32:04Q&A
related talks
48mMigrating to PostgreSQL: Strategies, Sovereignty, and Success
46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQL
34mPartitioning and Data Migrations Using PostgreSQL as an Example
34mPartitioning and Data Migrations Using PostgreSQL as an Example
45mSQL Server to PostgreSQL: Migration Challenges & Solutions
06mMigration Consideration Oracle to PostgreSQL
22mAccelerating PL/pgSQL Code Conversation When Migrating to Postgres
42mMigrating a database over 10TB from DB2 to PostgreSQL with zero downtime