Menu

#Alter

21 posts

Feed·
20 of 21 posts
A 3 ms ALTER can stall Postgres: how to migrate a 5-billion-row table with no downtime
📰
0Read More

A 3 ms ALTER can stall Postgres: how to migrate a 5-billion-row table with no downtime

DEV Community: postgres·Anderson·1 day ago
#3fAbGKRQ
#devtopostgresql#devto#dev#await#table

An ALTER TABLE that takes 3 ms can still stall every query on the table. In my first demo it took 3...

15s
Zero-Downtime Database Migration Strategies for Production
🖼️
0Read More

Zero-Downtime Database Migration Strategies for Production

DEV Community·丁久·6 months ago
#iZG1AYjg
#database#migrations#devops#postgres#column

How to safely run database migrations without downtime: expand-contract pattern, feature flags for migrations, backfill strategies, reversible migrations, and handling large tables (100M+ rows).

15s
6ix9ine Makes Shocking Comments About Girlfriend’s Pregnancy at Gender Reveal Party
🖼️
0Read More

6ix9ine Makes Shocking Comments About Girlfriend’s Pregnancy at Gender Reveal Party

Billboard·Mitchell Peters·6 months ago
#12TAsGtV
#close#search#mask#hamburger#arrow

From Billboard RSS Feed: 6ix9ine Makes Shocking Comments About Girlfriend’s Pregnancy at Gender Reveal Party

15s
Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)
🖼️
0Read More

Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)

DEV Community·Fan()·6 months ago
#FCysP3pV
#scenario#cli#database#showdev#table

From Dev Community: Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)

15s
Zero Downtime Database Migrations: A Practical Guide for PostgreSQL
🖼️
0Read More

Zero Downtime Database Migrations: A Practical Guide for PostgreSQL

DEV Community·SoftwareDevs mvpfactory.io·6 months ago
#7N1pLPes
#webdev#programming#software#coding#column

Step-by-step guide to performing schema migrations in PostgreSQL without any downtime. Cover ALTER TABLE tricks, CREATE INDEX CONCURRENTLY, adding columns with defaults, renaming via views, and real-world migration scripts.

15s