Postgresql Interview Questions — All Categories
4 questions tagged with Postgresql as a technology, across every category it appears in
Related categories:Databases
What would you do differently for a large-table backfill migration if the table were actively receiving high write throughput during the migration window?
ExpertPostgresql8 min
How would you monitor a batched backfill in production to know it's progressing safely, not falling behind, and not causing replication lag?
AdvancedPostgresql7 min
How would the safe-migration approach for adding a NOT NULL column to a large table differ on MySQL versus PostgreSQL, given their different online-DDL capabilities?
AdvancedMysqlPostgresql8 min
How do you safely add a NOT NULL column to a large production table without locking it for the duration of a slow backfill?
AdvancedPostgresql9 min